Split Date Range to Individual Dates

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?

For example:
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:
https://www.experts-exchange.com/questions/23653806/Split-Date-Range-into-Months.html