摘要：
1、根据一个日期获取到相应的周开始时间和周结束时间startDate=(select dateadd(ww,Case When datepart(Dw,'2013-04-01')= 7 Then (datediff(ww, 0, '2013-04-01')+1) Else datediff(ww, 0, '2013-04-01') End,-2)) endDate=(select dateadd(dd,6,(select dateadd(ww,Case When datepart(Dw,'2013-04-01')= 7 Then 阅读全文