Let's say I have a table with this data:
I would like a query that would give me each unique date including ones that fall between the start and end dates:
Selecting the unique start date is of course not a problem. I am scratching my head on how to grab the list of dates that are within a range.
Please help. Thanks.