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 |
|
Goalie35
Yak Posting Veteran
81 Posts |
 Posted - 2008-05-06 : 09:50:19
|
| I need to create something on a 2000 sql server that automatically updates a table every night. Basically, we have several dozen tables that collect different ordering information. I'll need to collect this data and store it in a single, nice & clean table for reporting purposes.Does anyone know of a good tutorial that shows how to do this? Thanks.-Goalie35 |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-05-06 : 11:17:08
|
| You basically need to create a stored procedure which performs the required actions to your table. You then need to create a sql job to call this procedure and schedule the job to execute every night at a convienient time. |
 |
|
|
|
|
|
Automatically updating table nightly?