DECLARE @startID AS integer DECLARE @endID AS integer SET @startID = (SELECT MIN(ID) FROM Log) SET @endID = (SELECT MAX(ID) FROM Log) INSERT INTO ArchiveLog SELECT * FROM Log WHERE ID BETWEEN @startID AND @endID Delete FROM LOG WHERE ID BETWEEN @startID AND @endID
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)