UPDATE MyTable1 SET ContactName = MyTable2.ContactName FROM MyTable1, (SELECT * FROM OPENXML (@idoc, '/ROOT/Customer',1) WITH (CustomerID varchar(10), ContactName varchar(20))) AS MyTable2 WHERE MyTable1.CustomerID = MyTable2.CustomerID>Ignore the PRE and /PRE tags in the previous message, the instructions I got for formatting the code were not clear enough, I was probably supposed to use something else.