I need to delete rows from more than one table 100 rows at a time. There is a main table, that determines what rows to delete. There are two columns that used to join the main table with others. Here is my solution:
created a temp table with the two columns that used for join; then use the "while" loop to delete rows from the secondary tables; then another "while" loop to delete from the main table.
Can anyone suggest any other way of deleting rows?