نویسنده : نویسندگان آزاد

DECLARE @StartDateTime DATETIME

DECLARE @EndDateTime DATETIME



SET @StartDateTime = '2020-10-10'

SET @EndDateTime = '2020-11-10';



WITH DateRange(DateData) AS

(

    SELECT @StartDateTime as Date

    UNION ALL

    SELECT DATEADD(d,1,DateData)

    FROM DateRange

    WHERE DateData < @EndDateTime

)

SELECT DateData

FROM DateRange

OPTION (MAXRECURSION 0)

GO

2020-10-10 00:00:00.000

2020-10-11 00:00:00.000

2020-10-12 00:00:00.000

2020-10-13 00:00:00.000

2020-10-14 00:00:00.000

2020-10-15 00:00:00.000

2020-10-16 00:00:00.000

2020-10-17 00:00:00.000

2020-10-18 00:00:00.000

2020-10-19 00:00:00.000

2020-10-20 00:00:00.000

2020-10-21 00:00:00.000

2020-10-22 00:00:00.000

2020-10-23 00:00:00.000

2020-10-24 00:00:00.000

2020-10-25 00:00:00.000

2020-10-26 00:00:00.000

2020-10-27 00:00:00.000

2020-10-28 00:00:00.000

2020-10-29 00:00:00.000

2020-10-30 00:00:00.000

2020-10-31 00:00:00.000

2020-11-01 00:00:00.000

2020-11-02 00:00:00.000

2020-11-03 00:00:00.000

2020-11-04 00:00:00.000

2020-11-05 00:00:00.000

2020-11-06 00:00:00.000

2020-11-07 00:00:00.000

2020-11-08 00:00:00.000

2020-11-09 00:00:00.000

2020-11-10 00:00:00.000