Thank you very much for your help. I only have a very basic understanding of CTEs but I'm sure I will be able to puzzle out exactly what's happening...

Thank you for pointing out proper posting etiquette. I had not seen that article before and I apologize.

IF OBJECT_ID('TempDB..#InterestRates','U') IS NOT NULL ...

Your script is correct and that is a good way to do deletes when you need to reference values in another table to find your records.

Yes I make a remote call to execute the stored procedure that is on the server where the data is housed. Thanks again.

Piotr, your script worked beautifully and dropped the runtime down from 4.5 hours to 4.5 minutes. Thank you very much. I took a look at how a sliding...

There are no foreign key constraints or triggers. The table has one clustered index on the date field.

No go last night, I forgot to enable RPC on the remoter server. I'm going to enable it now and I will post the results tommorow. BTW thanks...

The setting of the SET ROWCOUNT option is ignored for INSERT, UPDATE, and DELETE statements against remote tables and local and remote partitioned views. If I moved the stored...

Thanks for the tip. Turns out the account running the delete doesn't have the appropriate permissions to access statistics. I've made that change and I will report back...

So I added a clustered index to the datetime field and that brought the runtime down from 10 hours to 5 hours. This is acceptable since it now isn't...

The reason it is run from a different server is because before we delete all this data, we pull it over to an archive database. Once the archive is...