SQL: Show days between two date using CTE Recursion

preview_player
Показать описание
DECLARE @StartDate DATETIME = '2018-08-24 00:00:00.000',
@EndDate DATETIME = GETDATE();

;WITH CTE AS
(
SELECT DATEADD(DAY, 1, @StartDate) AS DateStart
UNION All
SELECT DATEADD(DAY, 1, c.DateStart) AS DateStart
FROM CTE c
WHERE c.DateStart = @EndDate
)

SELECT *
FROM CTE
Рекомендации по теме