34,590
社区成员
发帖
与我相关
我的任务
分享
DECLARE @EDate DATETIME=GETDATE()
,@SDate DATETIME
SELECT @SDate=CONVERT(DATE,@EDate),@SDate=DATEADD(Day,1-(DATEPART(Weekday,@SDate)+@@DATEFIRST-2)%7-1,@SDate)
--查看生成时间范围
SELECT @SDate,@EDate
select
(SELECT SUM(销售金额) FROM test WHERE (DATEPART(HH, 时间) = 07) and (DATEPART(DD, 时间) = 10) AND 时间 BETWEEN @SDate AND @EDate)
+
(SELECT SUM(销售金额) FROM test WHERE (DATEPART(HH, 时间) = 07) and (DATEPART(DD, 时间) = 10) AND 时间 BETWEEN @SDate AND @EDate)