Recurring Events Best Practice

[ifntech]

Looking to see what others have done to setup process for adding recurring events.

Similiar to scheduling a meeting every week.

Looking for best practice.


Stored procedures, auto generate, etc.???????

 

[SQLDenis]

I use scheduled jobs for that

Denis The SQL Menace
SQL blog:

http://sqlservercode.blogspot.com/

Personal Blog:

http://otherthingsnow.blogspot.com/

 

[ifntech]

Can you give me a little more detail.

The user will select recurring event weekly.

How would it show in the database.

Do you generate records for a set period out.
What happens if they cancel.

Do you have another job that then looks for those and deletes.

Trying to figure out the most efficient way to generate the records for viewing future events.

 

[SQLDenis]

Ok, I misunderstood, I thought you needed to run something once a week

can you show some sample code, what kind of data is this?

You can have an active bit field to handle the cancellations for example

Denis The SQL Menace
SQL blog:

http://sqlservercode.blogspot.com/

Personal Blog:

http://otherthingsnow.blogspot.com/

 

[ifntech]

I have no sample code yet.
events are stored in the records

I need the option of making an event recurring on ie. weekly or monthly basis.

I'm unsure on best way to manage recurring events.

If people actually generate future events as records or just some type of coded virtual event on event type of say recurring.