thanks. That is what I have done. Now it is running. But it is happening frequantly what could be the exact reason.

you can use trigger. Trigger will create automatically 2 table inserted and deleted. When you delete, from deleted table you can insert those records got deleted to the new...