Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 Recurring Bookings...

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2001-03-05 : 00:21:55
William writes "I have developed an ActiveX component to handle timetabling of resources (boardrooms etc.) And the bookings table looks something like this:

BookingID
BookingDate
SessionID
ResourceID
Requestor
Approved

One of my customers has asked me if it would be possible to do recurring bookings (eg every Tuesday, or every month on the 22nd). The SQL and table design has me stumped any suggestions?"

slserra
Starting Member

19 Posts

Posted - 2003-10-13 : 17:15:10
Jay, can you post the stored proc that has the algorithm
for adding recurring events based on the Outlook frequencies.

I'm doing something similar and do not want to re-invent the wheel.

Thanks in advance,

Steve Serra
Go to Top of Page
   

- Advertisement -