I am trying to figure out how best to deal with recurring events in a database. I want to be able to set an event that has a start date, no end date and can be recurring with different parameters (such as every monday, every month on the first day of the month, every month on the first thursday of the month, etc.) Does anyone have any pointers to documents on strategies for dealing with this? Right now I am leaning towards handling a lot of logic in my application layer but I would rather find an elegant T-SQL method for dealing with this. Of course, right now, I can't even figure out the best way to structure my tables.
Thanks,
Alex Gadea
Apptik Inc.