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 |
|
admin001
Posting Yak Master
166 Posts |
 Posted - 2002-08-02 : 12:05:46
|
| Hi ,I have a scheduled job which does an text file import in my database . The data gets appended in my table every day from this import job . Since my table is growing every day , i want to truncate the table after the data has been collected for three months i.e 90 days . The table will be empty and the new data will flow in through the import . Any thoughts how to do it through query and schedule it ???Thanks |
|
|
AndrewMurphy
Master Smack Fu Yak Hacker
2916 Posts |
|
|
|
|
|
Delete records in a table older than 90 days .