Is there a query that I can store on the SQL server that can take a result with a start date and end date and instead break it down to show that record for each date in the range?
A query outputs this record: MyEventTitle | 3/12/2008 | 3/15/2008
Instead of seeing that one line, I want to see this:
MyEventTitle | 3/12/2008
MyEventTitle | 3/13/2008
MyEventTitle | 3/14/2008
MyEventTitle | 3/15/2008
Basically the end date doesn't show and instead I see the record broken down by each date from the date range that was in the result.
I am doing this now with an RS.LOOP function while inserting records into a table but that seems redundant if I can just accomplish this while pulling the records in a query instead of having to insert them into yet another table.
I saw this posting which seems like it is on the right track for what I need but I want to be broken down for each date witihin a range and not each month: