The little tricks that I’ve found yesterday, is use the @@TRANCOUNT.

Make a rollback only if it’s equal to 1. It means that you are on the outer level and...

You could try something like this :

UPDATE a SET

a.updated = getdate(),

a.company = COALESCE(a_temp.company,a.company),

a.fname = COALESCE(a_temp.fname,a.fname),

a.lname = COALESCE(a_temp.lname,a.lname),

a.phone = COALESCE(a_temp.phone,a.lname),

Yeah, that’s exactly what I want to know. And effectively, I know that I must use nvarchar, nchar (Unicode data type) to insert some Unicode values. Just 2 other questions:

-...