Here's what I got so far...
declare @startdate as datetime, @enddate as datetime select @startdate = '12-26-2008', @enddate = '01-26-2009' select sum( case when datename(dw,dateadd(dd,days,@startdate)) in ('SATURDAY', 'SUNDAY') then 1 else 0 end) as 'Number of WeekEnd', sum( case when datename(dw,dateadd(dd,days,@startdate)) in ('SUNDAY') then 1 else 0 end) as 'Number of Sunday', sum( case when datename(dw,dateadd(dd,days,@startdate)) in ('SATURDAY') then 1 else 0 end) as 'Number of Saturday' from (select top 365 colorder - 1 as days from master..syscolumns where id = -519536829 order by colorder) x where datediff(dd,dateadd(dd,days,@startdate),@enddate) >= 0Here's the resultset:
Number of WeekEnd Number of Sunday Number of Saturday ----------------- ---------------- ------------------ 10 5 5Any suggestions to improve this code is always welcome...
~~CK
No comments:
Post a Comment