Query per ottenere un intervallo di date

DECLARE @start datetime = '20090201' , @end datetime = '20090217';

WITH Dates(dataRic) AS
(
    SELECT @start
    
    UNION ALL
    
    SELECT dataRic +1
    FROM Dates 
    WHERE dataRic < @end
) 
SELECT DataRic AS Data 
FROM Dates
OPTION(MAXRECURSION 0);

/* Output:

Data
-----------------------
2009-02-01 00:00:00.000
2009-02-02 00:00:00.000
2009-02-03 00:00:00.000
2009-02-04 00:00:00.000
2009-02-05 00:00:00.000
2009-02-06 00:00:00.000
2009-02-07 00:00:00.000
2009-02-08 00:00:00.000
2009-02-09 00:00:00.000
2009-02-10 00:00:00.000
2009-02-11 00:00:00.000
2009-02-12 00:00:00.000
2009-02-13 00:00:00.000
2009-02-14 00:00:00.000
2009-02-15 00:00:00.000
2009-02-16 00:00:00.000
2009-02-17 00:00:00.000

(17 row(s) affected)

*/