recurring events in a calendar

[id10t]

I've written a (fairly nice imho) calendar display program that uses a MS SQL server to hold the data. One of the problems I am having is with recurring events. Entering them day after day after day is a bit much, since some of them go for a month or two non-stop. What I'd like to do is give the person entering the data the option of a start and stop date. Then when it is submitted, some how cycle thru every date between the two to enter the information in hte SQL server.

Should it be something as simple as adding a day to the start date, creating a new date from that, sending the SQL statement, increment a counter, add the counter to the start date and repeating until start date + counter == end date? Or is there a better way?

[AstroTeg]

I would think ideally you would just want one record in your database saying event X starts on Y and ends on Z. Then you can do some query magic to retrieve this event from within a date range (if its in range, then you show the event).

The trick is is it as simple as just storing the event info, event start date, and event date? Depends on how you have your database designed.

I would personally stay away from trying to represent event X with multiple records. Things get really messy when it comes time to update or delete event X and all its records.