It has been created based on some standards created by the hotel industry for generating flat files for all hotel chains which have to be imported in to this table.

Thanks for your help. I will test the queries I generate before posting them here to make sure they work.

Thanks. Indexes won't help a lot in this case and I need to change the way I am doing this comparison. I had posted the second table create statement but...

I did not post the create and insert statements in my last post

CREATE TABLE [dbo].[projectdata](

[InvoiceId] [int] IDENTITY(1,1) NOT NULL,

[ProjectId] [int] NOT NULL,

[CompanyCode] [varchar](2000) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,

[VendorNumber] [varchar](2000) COLLATE SQL_Latin1_General_CP1_CI_AS...

This query is run only once for any of the tables and the data is received in a text format and then imported so we have to use like statements

Its taking 3minutes now compared to 25 minutes earlier.

thanks. This worked great.

This looks that it might work. You can change Identity insert to on before inserting records. I am trying to write a update statement. Can you modify this select to...

Actually the issue of not updating multiple rows was happening because theof the workaround second update query I wrote to update the duplicate_with field to have the lowest id and...

Please check my last 2 messages and I noticed 1 more issue with this. If there are more than 2 matching rows only the first matching row gets updated and...

I ran it again and noticed that 1 and 4 were duplicates and the duplicate_with field for 1 had the value 4 and duplicate_with for 4 had the value 1.What...

What I am saying is if invoiceid 1 is same as invoice 2, 3 and 4 I want the duplicate_with field to have the value 1 for all invoiceids 1,2,3,4....

THanks. I ran the following for my exact duplicate type records and it was much faster but since you have vpsinvoice.InvoiceID <> MyAlias.InvoiceID it did not update the parent record...

this looks good. why are you grouping those 5 fields in the subquery?

Hi,

Were you able to check the create and insert statements I had sent. I did not give the following information in my last message and thats probably why you could...