MSSQL 주말 추출 쿼리

 

declare @date1 datetime
declare @date2 datetime
--select @date1 dateadd(qq, datediff(qq,0,getdate()),0)
--select @date2 dateadd(qq, datediff(qq,-1,getdate()),-1);

select @date1 = '1/1/2009'
select @date2 = '12/31/2009';

with cte (dt) as
(
select @date1
union all
select dateadd(d,1,dt) from cte
where dt < @date2
)
select dt, datename(dw,dt) from cte option (MAXRECURSION 0)
--where datename(dw,dt) in ('saturday', 'sunday')
where datename(dw,dt) in ('토요일', '일요일')
option (maxrecursion 0)