BETWEEN is purely simpler to read. There is no specific engine enhancements that make BETWEEN any faster.

Just FYI the index changes may have had some impact but that much seems like it was possible more of a maintance issue. The problem is you just never know...

Also, before I forget. Make sure you test on a none production machine, backup the database before actually running, and use a BEGIN TRAN before you run this part

CREATE TABLE...

First is ACCOUNT_PRODUCT the only table that will have a reference to PRODUCT ?

If so I suggest something like this.

CREATE TABLE dbo.Temp_Products (

 PRODUCTID char(2) NOT NULL,

 CODE VARCHAR(30) NOT NULL PRIMARY...

I would be curious as well.

I agree with Mike's statements. You cannot assume Berger King and Burger King are the same company.

I have seen on a few occasions that names can look similar for...

A few questions:

1) How many records are you talking.

2) Does the data need to be unique on some or all of the columns, which ones?

If the data doesn't need to...

Based on what I see this might help.

Consider change the indexes on AccountingDocumentitem to

Clustered Index

  AccountingDocumentNbr, FiscalYearNbr, MSGLCompanyCode

Non-Clustered Indexes

1) BillingDocumentNbr, MSAccount2Code

2) ClearingAccountingDocumentNbr

3) CustomerNbr

4) AccountingDocumentItemNbr

Remember your clustered index is effectively...

The purpose of an IDENTITY property is to create a uniqness to a record that does not have a naturally occurring key or to act as a surrogate in replacing...

Does wrkAccountingDocument have any indexes.

Also, can you post the DDL of the table (CREATE statement) so I can see the structure and let me know which columns if any are...

I believe the only reason for it's support is to be able to span multiple logical drives. That is the only reason I have ever seen where you would need...

I would suspect yes, but canot find anything on MS site or elsewhere to say 100 percent for sure.

Take a look in the Windows Event viewer for that time fram under system and application. I suspect you will find an insufficient memory event. Sounds like you tried to...

That name sounds like it might be part of package logging found under the package properties. Check there.

All cursors whether in your scope or not or just those in your scope, either way I believe there is a system XP or SP for that but don't have...