I have a table of events with start dates and end dates.
If I have a record that looks like this...
eventideventDateendDate
11/15/20112/5/2011
If I query the table like so...
SELECT * FROM events WHERE eventDate BETWEEN '1/1/2011' AND '1/31/2011'
I get the expected result which is a single record.
How could I get the query to return a record for each day between 1/15/2011 and 2/5/2011?
Basically I would get 21 rows in my result set instead of the one.