Re: Updating multiple records

["The ScareCrow" <info@xxxxxxxxxxxxxxxxxxxxxxxxx>]

It does sound insteresting and tempting doesn't it !!

 The sql server BOL have some examples, here is just one

 Enjoy

 Ken

 The example also shows a SELECT statement with OPENXML that retrieves 
CustomerID and OrderDate from the XML document.

 DECLARE @hDoc int
 EXEC sp_xml_preparedocument @hDoc OUTPUT, 
       N'<ROOT>
          <Customers CustomerID="XYZAA" ContactName="Joe" 
                CompanyName="Company1">
             <Orders CustomerID="XYZAA" 
                OrderDate="2000-08-25T00:00:00"/>
             <Orders CustomerID="XYZAA" 
                OrderDate="2000-10-03T00:00:00"/>
          </Customers>
          <Customers CustomerID="XYZBB" ContactName="Steve"
                CompanyName="Company2">No Orders yet!
          </Customers>
       </ROOT>'
 -- Use OPENXML to provide rowset consisting of customer data.
 INSERT Customers 
 SELECT * 
 FROM OPENXML(@hDoc, N'/ROOT/Customers') 
      WITH Customers