This is possible through Recursive CTEs. You can execute the below code logic by passing @Start and @End variable values. DECLARE @Start datetime = ’02/08/2016′ DECLARE @End datetime = ’02/13/2016′ ;WITH Auto_Date AS (     SELECT @Start AS Dates_List    UNION ALL

Read More