I have an XML message which is first read and inserted into a table using OPENXML. The next time the message comes it will contain only the modified values. In that case I should update only those columns which have been modified and the remaining column values should remain unchanged. How can I do this? I can read all the nodes in the XML using OPENXML excluding the WITH clause. But after that how can I selectively update the columns corresponding to the nodes retrieved?