Author: Mike C#
Date: Feb 21, 2008 21:59
... using the .value() method and use that to insert new nodes in table2 with XML DML if you decide to go the XML DML route. <ndillon45@gmail.com> wrote in message news:f03870e2-ad03-4a80-ba56-6384d6fa428c@b29g2000hsa.googlegroups.com... I figured out how to extract the nodes: SELECT NewTable.Member.query('.') FROM table1 CROSS APPLY xml_data.nodes('/group/member') AS NewTable(...
|