强制查询返回所有范围,即使没有数据

你需要一个 LEFT JOIN ,但也可以使用 APPLY

SELECT ranges.range, SUM(v.Remaining) as Suma,
       COUNT(*) as Docs
FROM (VALUES ('Late 1 to 14 days', 1),
             ('Late 15 to 30 day', 2),
             ('Late over 30 days', 3)
     ) ranges(range, ord) LEFT JOIN
     (dbo.MyData d CROSS APPLY
      (VALUES (DATEDIFF(day, d.PaymentDate, GETDATE()),
               WN - MA
              )
      ) v(DaysLate, Remaining) CROSS APPLY
      (VALUES (CASE WHEN v.DaysLate BETWEEN 1 AND 14
                    THEN 'Late 1 to 14 days'
                    WHEN v.DaysLate BETWEEN 15 AND 30
                    THEN 'Late 15 to 30 day'
                    ELSE 'Late over 30 days'
               END)
      ) v1(range)
     )
     ON v1.range = ranges.range                  
WHERE v.DaysLate > 0 AND
      KOD_ID = @KOD_ID
GROUP BY v.range, v.ord
ORDER BY v.ord;