The table is about 4 Million rows, very big, but the temp table idea seems to be working, thanks.

Wel, I think that should work. Thanks.

Our ETL process the following..

We have mainframe files that get loaded at night, and basically the ETL will load the file into a...

Agree, cursors are bad and we are staying away from those!!

The current delete statment takes about 872729 ms, which is kind of high, and what the delete does is delete...