Looks like the latest version of SQLXML is here:http://www.microsoft.com/downloads/details.aspx?FamilyId=228DE03F-3B5A-428A-923F-58A033D316E1&displaylang=en
Not something I've used I'm afraid - just something I was aware of - so I don't really know whether it will suit your requirements....
>Thank you. I will follow the link.
>
>>Maybe you can let SQLServer do it for you. See the latter part of this link for a (VB) example:
>>
http://www.informit.com/articles/article.aspx?p=101369&seqNum=5>>
>>>I want to see if I can build an UPDATE command from the DiffGram XML in a stored procedure.
>>>
>>>>
>>>>Why do you want to do that ?
>>>>
>>>>>
>>>>><?xml version="1.0"?>
>>>>><diffgr:diffgram xmlns:msdata="urn:schemas-microsoft-com:xml-msdata"
>>>>>xmlns:diffgr="urn:schemas-microsoft-com:xml-diffgram-v1">
>>>>> <CustomerDataSet>
>>>>> <Customers diffgr:id="Customers1" msdata:rowOrder="0" diffgr:hasChanges="modified">
>>>>> <CustomerID>ALFKI</CustomerID>
>>>>> <CompanyName>New Company</CompanyName>
>>>>> </Customers>
>>>>> <Customers diffgr:id="Customers2" msdata:rowOrder="1" diffgram:hasErrors="true">
>>>>> <CustomerID>ANATR</CustomerID>
>>>>> <CompanyName>Ana Trujillo Emparedados y helados</CompanyName>
>>>>> </Customers>
>>>>> <Customers diffgr:id="Customers3" msdata:rowOrder="2">
>>>>> <CustomerID>ANTON</CustomerID>
>>>>> <CompanyName>Antonio Moreno Taquera</CompanyName>
>>>>> </Customers>
>>>>> <Customers diffgr:id="Customers4" msdata:rowOrder="3">
>>>>> <CustomerID>AROUT</CustomerID>
>>>>> <CompanyName>Around the Horn</CompanyName>
>>>>> </Customers>
>>>>> </CustomerDataSet>
>>>>> <diffgr:before>
>>>>> <Customers diffgr:id="Customers1" msdata:rowOrder="0">
>>>>> <CustomerID>ALFKI</CustomerID>
>>>>> <CompanyName>Alfreds Futterkiste</CompanyName>
>>>>> </Customers>
>>>>> </diffgr:before>
>>>>> <diffgr:errors>
>>>>> <Customers diffgr:id="Customers2" diffgr:Error="An optimistic concurrency violation has occurred for this row."/>
>>>>> </diffgr:errors>
>>>>></diffgr:diffgram>
>>>>>
