select number+1 as wknum,dateadd(wk,number,'2017-01-01') as firstday,
(case when year(dateadd(d,-1,dateadd(wk,number+1,'2017-01-01')))>2017 then '2017-12-31'
else dateadd(d,-1,dateadd(wk,number+1,'2017-01-01')) end) as sevenday
from master..spt_values
where type='p' and year(dateadd(wk,number,'2017-01-01'))=2017

原文链接： https://blog.csdn.net/qq_42988813/java/article/details/88403555