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