>Edward,
>
>I think the problem is that you might run out of records to delete from the latter tables, maybe the process should start with the tables ordered by the number of records to delete to minimize this.
>
>Ex. (r records and d records to delete)
>
>T1: 500r 30d
>T2: 100r 10d
>T3: 111r 3d && You might already run out of duplicates to delete from this table
I'm not sure I follow all of you. Obviously in each table we have different set of records to delete, e.g. some specific records.
E.g. we have "Test1" in Table1 and Table2. We need to figure out from which table we need to delete "Test1". Did I understand the problem?
If it's not broken, fix it until it is.
My Blog