I have a table with 2 dates, Start Date and End Date. I need to find all dates within the range between Start Date and End Date. So if the start date is 05/01/2016 and the end date is 05/06/2016 the output should be
The database i am working with has a table called Date dimension. This lists all dates from 1850 to sometime in the future. I was wondering if I could use a CTE with this table to find these dates or if there is a better way.