ФУНКЦИЯ - Получить список дат

DECLARE @DATE_START DATETIME = '07-28-2019 00:00:00.001'
DECLARE @DATE_END DATETIME = '07-30-2019 23:59:59.000'

DECLARE @DATES TABLE ([Day] DATE)

DECLARE @cur_date DATE = CAST(@DATE_START AS DATE)

DECLARE @iterator INT = 0

WHILE @iterator < DATEDIFF(DAY, @DATE_START, @DATE_END) + 1
BEGIN
    INSERT INTO @DATES VALUES(@cur_date)
    SET @cur_date = DATEADD(DAY, 1, @cur_date)
    SET @iterator = @iterator + 1
END

SELECT * FROM @DATES