Not tested,

but I think this kind of query can work....

--------------------------------

Update OriginalTable

set

OriginalTable.Field2=tempTable.field2,

OriginalTable.Field3=tempTable.field3

from tempTable

where OriginalTable.Field1=tempTable.Field1

------------

I was looking on OPENXML examples, when this idea comes in my mind. will test, will look forward for more replies till then.

Regards,

Azam.