i am trying to prepare a SQL query that will copy marked as archive data from main tables to backup tables.trying to figure out the correct query for the same, can anybody please guide me.i think i should start from delete query and modify the function to do archiving instead.

Have not looked into this, but your idea to add the function based on the delete function sounds really good to me.

Write a Reply...