590
社区成员
发帖
与我相关
我的任务
分享
;WITH TabDate(Dt)
AS
(
SELECT CAST('2016-08-01 21:00:00' AS DATETIME)
UNION ALL
SELECT DATEADD(n,10,Dt) FROM TabDate WHERE Dt<'2016-08-03 21:00:00'
)
SELECT a.Dt,b.*
FROM TabDate AS a
LEFT JOIN TableName AS b ON b.日期列>=a.dt AND b.日期列<DATEADD(n,10,Dt)
OPTION(MAXRECURSION 0)
;WITH TabDate(Dt)
AS
(
SELECT CAST('2016-08-01 21:00:00' AS DATETIME)
UNION ALL
SELECT DATEADD(n,10,Dt) FROM TabDate WHERE Dt<'2016-08-03 21:00:00'
)
SELECT a.Dt,COUNT(1) AS 记录数
FROM TabDate AS a
LEFT JOIN dbo.BStable AS b ON b.日期时间>=a.dt AND b.日期时间<DATEADD(n,10,Dt)
GROUP BY a.Dt
OPTION(MAXRECURSION 0)
;WITH TabDate(Dt)
AS
(
SELECT CAST('2016-08-01 21:00:00' AS DATETIME)
UNION ALL
SELECT DATEADD(n,10,Dt) FROM TabDate WHERE Dt<'2016-08-03 21:00:00'
)
SELECT a.Dt,COUNT(1) AS 记录数
FROM TabDate AS a
LEFT JOIN TableName AS b ON b.日期列>=a.dt AND b.日期列<DATEADD(n,10,Dt)
GROUP BY a.Dt
OPTION(MAXRECURSION 0)