计算周末和平时天数

 

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)) )