Hi I'm going to be archiving data from one table to another based on a set of rules.
The records must be older than 3 months AND (
The complete field = 0 OR (The complete = 1 AND the downloaded field = 1))
I am going to use a stored procedure to do this and call it from an ASP script.
Firstly I need to know how to write the SQL which will pull out a recordset of records to be archived then delete the records from the table and then insert them into the archived table.
Can anyone advise me of the best way to go abot doing this?
Any help would be much appreciated!
Mayoor
The records must be older than 3 months AND (
The complete field = 0 OR (The complete = 1 AND the downloaded field = 1))
I am going to use a stored procedure to do this and call it from an ASP script.
Firstly I need to know how to write the SQL which will pull out a recordset of records to be archived then delete the records from the table and then insert them into the archived table.
Can anyone advise me of the best way to go abot doing this?
Any help would be much appreciated!
Mayoor