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.
| Author |
Topic |
|
Fishboy
Starting Member
1 Post |
 Posted - 2006-05-23 : 09:38:04
|
| I have a table that stores weekly event information for 24 events. The event numbers, times, and locations all stay the same. The only thing that changes is the date, which moves one week out for each event. Is there a way to have the events duplicate themselves via a trigger or stored procedure or is BULK INSERT my best bet for populating the table?Thanks! |
|
|
mwjdavidson
Aged Yak Warrior
735 Posts |
Posted - 2006-05-30 : 06:09:04
|
| You're probably best off scheduling a job to run a stored procedure to do this. Can you post some DDL and sample data? It sounds like you may be duplicating information unnecessarily (if you are restating the event numbers, locations, etc. each month), but it's hard to say without more detail. |
 |
|
|
|
|
|
Recurring Data