SELECT DATEPART(WEEK,DATEADD(DAY ,7-DATEPART(WEEKDAY,datetime),datetime)),*,DATEADD(DAY,-6,(DATEADD(DAY ,7-DATEPART(WEEKDAY,datetime),datetime))),DATEADD(DAY ,7-DATEPART(WEEKDAY,datetime),datetime)
FROM (
SELECT DATEADD(DAY,-6+id,@star_date)datetime
FROM sys_dictionary WHERE DATEADD(DAY,id,@star_date)<=@end_date
)A
FROM (
SELECT DATEADD(DAY,-6+id,@star_date)datetime
FROM sys_dictionary WHERE DATEADD(DAY,id,@star_date)<=@end_date
)A
扫一扫
816
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
