주차 뽑아내기
declare @date char(6)set @date = '200705' ;with cte_date as( select convert(datetime,@date + '01') date, datepart(dw,convert(datetime,@date + '01')) t union all select date + 1, datepart(dw,date + 1) from cte_date where date + 1 1
DataBase/SQL Server
2013. 12. 23. 12:27