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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2005-06-30 : 07:45:21
|
| Nitin writes "Hi Team,I have twoTables. 1>tblSchedule and 2>tblActive. tblSchedule has the predefined times events. Typical record of tblSchedule is like:EventID EventDateTime Description--------------------------------------- 1 06/24/05 9:15 B'Day 2 06/24/05 10:15 PartyNow I want that every record from tblSchedule needs to be automatically transfered on its date and time to the tblActive. The tblActive has the same structure as of tblSchedule. How this can be done. Pls suggest..." |
|
|
dsdeming
479 Posts |
Posted - 2005-06-30 : 07:56:36
|
| You should probably create a SQL Agent job that runs nightly and transfers the rows to tblActive based on the date.Dennis |
 |
|
|
|
|
|
scheduled insert query