SQL: Turn a Date Range into a List of Dates

I’m working on a project today that deals with date ranges being stored in SQL Server. Imagine a row in a table with a starting and an ending date. My desired output is to transform each single row into several, one for each date within the given date range.
Read more…

Tags: cte, recursive, sql