How to list all dates between two dates

Question

AVADHESH PATEL · Answer

Hi Kate!Create a stored procedure that does something like the following:declare @startDate date;declare @endDate date;select @startDate = '20150528';select @endDate = '20150531';with dateRange as( select dt = dateadd(dd, 1, @startDate) where dateadd(dd, 1, @startDate) &lt; @endDate union all select dateadd(dd, 1, dt) from dateRange where dateadd(dd, 1, dt) &lt; @endDate)select *from dateRangeI hope it helpful for you.

forum

How to list all dates between two dates

Can you answer this question?

1 Answers