巧妙运用master..spt_values查询时间

with tbzs as( 
    select distinct datepart(week,allday.dates) weekRange, 
    dateadd(Day,1-(datepart(Weekday,allday.dates)+@@datefirst-1)%7,allday.dates) firstDay, 
    dateadd(wk, datediff(wk,0,allday.dates), 6) endDay 
    from ( 
        select CONVERT(varchar(10),dateadd(dd,number,dateadd(year,datediff(year,0,getdate()),0)),23) as dates 
        from master..spt_values 
        where type='p' 
        and dateadd(dd,number, dateadd(year,datediff(year,0,getdate()),0))<getdate()
    ) allday 
) 
select datename(yy,endDay) as nf, weekRange, firstDay, endDay 
from tbzs 
order by weekRange desc