SQL Server queries how many weeks and weekly date periods are in a time period

SQL statements

Select  Number+1  asWknum,DateAdd(WK, Number,'2017-01-01') asFirstDay, ( Case  when  Year(DateAdd(d,-1,DateAdd(WK, Number+1,'2017-01-01')))> .  Then '2017-12-31' Else DateAdd(d,-1,DateAdd(WK, Number+1,'2017-01-01'))End) asSevenday fromMaster.. Spt_valueswhereType='P'  and  Year(DateAdd(WK, Number,'2017-01-01'))= .

Results

This article quoted: http://www.myexception.cn/sql-server/327685_3.html

SQL Server queries how many weeks and weekly date periods are in a time period