SQL SERVER查询本周数据，无数据补0

SELECT CONVERT(varchar(100), temp1.RQ, 23) AS RQ,CONVERT(varchar(100), temp2.CreateTime, 24) as SBSJ,isnull(temp2.JRTW,0) as TW
FROM (
SELECT dateadd(day, number, CONVERT(nvarchar(10), DATEADD(wk, DATEDIFF(wk, 0, DATEADD(dd, -1, getdate())), 0), 121)) AS RQ
FROM master.dbo.spt_values
WHERE type = ‘P‘
AND number <= DATEDIFF(day, CONVERT(nvarchar(10), DATEADD(wk, DATEDIFF(wk, 0, DATEADD(dd, -1, getdate())), 0), 121),
CONVERT(nvarchar(10), DATEADD(wk, DATEDIFF(wk, 0, DATEADD(dd, -1, getdate())), 6), 121))
) temp1
LEFT JOIN (
SELECT RQ,CreateTime,JRTW
FROM [dbo].[yq_detailinfo]
WHERE SFZH = ‘220802198801211523‘
AND rq >= DATEADD(wk, DATEDIFF(wk, 0, DATEADD(dd, -1, getdate())), 0)
AND rq < DATEADD(wk, DATEDIFF(wk, 0, DATEADD(dd, -1, getdate())), 7)
) temp2
ON temp1.RQ = temp2.RQ
order by RQ desc;

SQL SERVER查询本周数据，无数据补0

原文：https://www.cnblogs.com/Anthony518/p/12316371.html