table1:

eventid

event

startDate

EndDate

recurFlag 'yes or no'

Table2

recurValID

recurVal

eventid

I need to do a select that will bring back 5 days of events. So getdate()+5....

then I need to join it with table 2...

Well I do not have the tables all built yet, but I was thinking of building a event table and then a recur table, because events can happen like every...

No. events. like every Tuesday We have a management meeting