>>Sounds to me you need to use temp table with the original IDs and the ID of the records which are left and then re-map everything.
>
>I went with the temp table and it worked like a charm. Thanks.
Did the process take 2 months? :) Just kidding, glad it worked.
If it's not broken, fix it until it is.
My Blog