CREATE PROCEDURE uspGetAddress AS INSERT INTO Table1_Backup(Column1, Column2) SELET Column1, Column2 FROM tblManpowerCollection WHERE DateColumn BETWEEN '01-10-2013' to '05-05-2013' --Insert records to backup table before delete DELETE FROM Table1 WHERE DateColumn BETWEEN '01-10-2013' to '05-05-2013' --Delete records after backup
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)