Thanks mate,

The second one works a treat

Thanks

phew,

Thanks Allen mate, I really appreciate your help

Have a good weekend and take it easy.

Thanks very much

Ben

update: 28 hours and counting for my query.

Buy we have another shed of a server I call Oldboy

I copied the tables in question accross to Oldboy

then reduced the field sizes...

Cheers AJ

I'll give it a wirl

Thanks

I agree, I'm concerned that the un indexed one could go forever

ben

Having looked at the predicted execution plan I have 12 table scans and having seen this comment

"Index or table scans: May indicate a need for better or additional indexes."

at

I've now realised (thanks to your help) that I shoudl have indexed the Duns column.

I imported both the files from CSV files and, being a fool, did't index!

I can't stop...

Having looked at it

There are about 1.6 million matches

So thats 1.6M x 10 = 16Million fields to update

I'm now thinking that's going to take at least a day.

I don't think...

I've got the people who want the data on my back telling me that the bloke who I replaced used to do it in 'a couple of hours'

It's a bit...

Thanks Allen,

I ran a test on both and they both worked.

I agree with you the first looks much nicer.

I'm going to look into indexing to see if I can improve...

Having browsed the web, I think my problem may be related to having two tables in the from clause, I'm therefore attempting the same using the EXISTS claus.

UPDATE [ukmf_final_complete]

SET

[ukmf_final_complete].[Company]...

Thanks both,

Yep, you're right!

The column I was using insn't unqiue.

Thanks very much,

Do you know if, with SQL Server, it is possible to run queries accross databases from different servers?

I have...