Data archiving

Your Customer table has a field Completed and a field Continued. The business requirement states that when a record with Completed set to 1 and Continued set to 0, it must be immediately moved to Customer_archive table.

Solution:

Create a DML trigger to accomplish it.