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 |
|
Rex Mundi
Starting Member
1 Post |
 Posted - 2005-04-11 : 09:43:03
|
| Hi everyone,Im wondering if it is possible, and if so, if anyone knows how, to write a small script that, Every Monday, gets the Date and Stores it in a table. Its seems feasible when you say it, but i haven'r a clue how to do it.Any Ideas or Suggestions?ThanksRex |
|
|
AndrewMurphy
Master Smack Fu Yak Hacker
2916 Posts |
Posted - 2005-04-11 : 09:50:34
|
| delete from tablexinsert into tablexselect getdate()wrap above in a SP.then look into SQL Agent to schedule theSP to run on whatever calendar you wish |
 |
|
|
|
|
|
Rules?