Thanks Lowell your example works,

I also note the warning provided by SteveB. I understand this and I am hoping this is just temporary until the company that support us...

Thank you to all contributors on this one. After removing the extra ON statement and changing the IS NULL to ='' the update worked perfectly.

😀

At the moment the socialsecnr column is empty as it is not used, however going forward I need to use this column as part of an import process that uses...

That will teach me to just copy and paste! Should have checked before I posted. dohh

Anyhow I have corrected and althogh it now runs there are 0 rows...

Hi, I have amedned the sript to use the valid table names and parsed the quesry toc heck before running but received the usual SQL error message as per below.

BEGIN...

Cheers guys, I have copied the database over to a test database so I will try on this one first.

I was looking at merge statements and was getting confused, this...

Thank you for the quick replies. I will look into the max memory setting and hopefully this will resolve the issue.

Lee

we use 64 bit operating system

I sort of knew we should use max memory but could not think of settings to use.