sql server 列举获取最近10个月。10周

1.列举最近10个月

select year(F_MonthDay) f_year,month(F_MonthDay) f_month from (
SELECT DATEADD(mm,number,dateadd(mm,-9,getdate())) AS F_MonthDay FROM master..spt_values WHERE TYPE = 'P' AND DATEADD(mm,number,dateadd(mm,-9,getdate())) <= getdate() )c

　　

2.列举最近10周

select year(F_WeekDay) f_year,DATEPART(week, F_WeekDay) F_Week from (
SELECT DATEADD(wk,number,dateadd(wk,-9,getdate())) AS F_WeekDay FROM master..spt_values WHERE TYPE = 'P' AND DATEADD(wk,number,dateadd(wk,-9,getdate())) <= getdate() )c