計算周末和平時天數

 

create  PROCEDURE usp_Gettime

 @starttime datetime,
 @endtime datetime
 
 /*計算周末平時天數*/

AS
declare @a int,@b int

 select @a= (select datediff(ww,@starttime,@endtime)*2
+(case when datepart(dw,@starttime)=1 then 1 else 0 end)
+(case when datepart(dw,@endtime)=7 then 1 else 0 end)  )

union 

 select @b=(    select datediff(dd,@starttime,@endtime)+1
  -(datediff(ww,@starttime,@endtime)*2
  +(case when datepart(dw,@starttime)=1 then 1 else 0 end)
  +(case when datepart(dw,@endtime)=7 then 1 else 0 end)) )