sql server 查询某个时间段共有多少周及每周的日期段
sql 语句
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
结果如图
本文引自:http://www.myexception.cn/sql-server/327685_3.html