From: "Daniel Bertin" <bertin@...>

>
> How can I do a SQL to move a bunch of rows from one table to another
> (identical) table?
>
> I want to move all the rows, where current_date - 30 from tableA to TableB
> then remove the rows from tableA

Try this: (it is untested and off the cuff)


Set Term ^;

CREATE PROCEDURE MoveTableARows(StartDate Date, EndDate Date)
RETURNS Complete CHAR(1)
AS
Begin
Complete = "T";
Insert into TableB Select * from TableA where TableA.DateField between
:StartDate and :EndDate;
Delete from TableA where DateField between :StartDate and :EndDate;
When Any do
Complete = "F";
EXIT;
end^

Set Term ;^

HTH
Woody