InstantForum.NET v4.1.4SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comTue, 16 Mar 2010 18:03:58 GMT20http://www.sqlservercentral.com/Forums/Topic808516-149-1.aspx[code="sql"]declare @xml xmlset @xml = '<items><item id="1" ISDELETED="D"></item><item id="2" ISDELETED="D"></item><item id="3" ISDELETED="D"></item></items>'Update MyTableSet ISDELETED = B.ISDELETEDFrom MyTable AInner Join ( select xmlcol.value('@id','int') as ID, xmlcol.value ('@ISDELETED', 'char(1)') as IsDeleted from @xml.nodes ('/items/item') tbl (xmlcol) ) B on B.ID = A.ITEMID[/code]Thu, 29 Oct 2009 23:38:53 GMTAtif Sheikhhttp://www.sqlservercentral.com/Forums/Topic808516-149-1.aspxYou can use the noeds and value XML methods together in order to get the information in tabular format. If you’ll do it in a CTE, you’ll get the results and you’ll be able to use it as if it was a table. Here is the part that creates the CTE. From here it is just a regular update statement that uses 2 tables.[code]declare @xml xmlset @xml = '<items><item id="1" ISDELETED="D"></item><item id="2" ISDELETED="D"></item><item id="3" ISDELETED="D"></item></items>';with MyCTE as ( select xmlcol.value('@id','int') as ID, xmlcol.value ('@ISDELETED', 'char(1)') as IsDeleted from @xml.nodes ('/items/item') tbl (xmlcol))select * from MyCTE[/code]Adi Mon, 26 Oct 2009 10:09:29 GMTAdi Cohn-120898http://www.sqlservercentral.com/Forums/Topic808516-149-1.aspxHello,I want to update a table from xml that is supplied. My XML<items><item id="1" ISDELETED="D"></item><item id="2" ISDELETED="D"></item><item id="3" ISDELETED="D"></item></items>I need to update isdeleted field depending on the ID. Table name TBL_NEWSplease provide me the stored procMon, 26 Oct 2009 01:38:49 GMTbabitheboy