... A("@member_id") order by "@member_id" for xml path('member'), type) from T2gid ... update with the XML DML statement only inserts a single node from table1 ...Thanks, Mike. This works for 1 node: DECLARE @insertStmt nvarchar(MAX) DECLARE @... 'UPDATE table2 SET sync_data.modify(''insert ' + @insertXML + ' before (/group/member[1])[1...

...FROM tab1 cross apply x.nodes('/group/member') as N(m...member_id") order by "@member_id" for xml path('member'), type) from T2gid...with the XML DML statement only inserts a single node from...Mike. This works for 1 node: DECLARE @insertStmt nvarchar(MAX) DECLARE...UPDATE table2 SET sync_data.modify(''insert ' + @insertXML + ' before (/group/member[1...

...member_id") order by "@member_id" for xml path('member'), type) from T2gid ...with the XML DML statement only inserts a single node from...table2, when it should be inserting them all. I'm probably...Mike. This works for 1 node: DECLARE @insertStmt nvarchar(MAX) DECLARE...UPDATE table2 SET sync_data.modify(''insert ' + @insertXML + ' before (/group/member[1...

... some reason SET Member.modify('insert <member member_id="{sql:column(''member_id... with the XML DML statement only inserts a single node from ... Mike. This works for 1 node: DECLARE @insertStmt nvarchar(MAX) DECLARE ...FROM table1 CROSS APPLY xml_data.nodes('/group/member') AS NewTable(Member...UPDATE table2 SET sync_data.modify(''insert ' + @insertXML + ' before (/group/member[1...

Thanks, Mike. This works for 1 node: DECLARE @insertStmt nvarchar(MAX) DECLARE @insertXML ...('.')) FROM table1 CROSS APPLY xml_data.nodes('/group/member') AS NewTable(Member) ... = 'UPDATE table2 SET sync_data.modify(''insert ' + @insertXML + ' before (/group/member[1])[1... @insertStmt ...but not for multiple nodes. I guess I'll have to use a cursor and insert one node at a time...

... that to insert new nodes in table2 with XML DML if you decide to go the XML DML route. <ndillon45@gmail.com>... figured out how to extract the nodes: SELECT NewTable.Member.query('.')... FROM table1 CROSS APPLY xml_data.nodes('/group/member') AS NewTable(Member...member_id', 'int') FROM table2 CROSS APPLY sync_data.nodes('/group/member') AS...

I figured out how to extract the nodes: SELECT NewTable.Member.query('.') FROM table1 CROSS APPLY xml_data.nodes('/group/member') AS NewTable(Member) WHERE pk_column_id... ref.value('@member_id', 'int') FROM table2 CROSS APPLY sync_data.nodes('/group/member') AS node(ref) WHERE pk_column_id = 1) Now I just need to know how to...

In SQL Server, how would you extract: <member member_id="3" /> <member member_id="4" /> from a sql column of type xml with value: <group group_id="1"> <member member_id="2" />... member_id="4" /> <member member_id="5" /> </group> and insert (the above extraction) into another sql column of type xml with current value: <group group_id="2"> <member member_id="2...

... parent axis navigation, possibly with stacked nodes() methods through CROSS APPLY. Also, ...h.data.value (@a , 'int' ) from @xml.nodes(/parent/child) as h(data...as attributes of this element. I extract it current by loading the data...) as h(data) then I insert the .value into an int table... the schema functionality with the xml data type. Expert help would ...

... @debug_yn = 1 SELECT @sql -- Extract loaded XML EXEC sp_executesql @sql, N'@xml...x.y.value( '@type', 'SYSNAME' ) FROM @xml.nodes( '//xs:element' ) x(y) ...Add sql:is-constant attribute SET @xml.modify( 'declare namespace sql="urn:schemas-microsoft-com:mapping-schema"; insert attribute sql:is-constant{1} ... IF @debug_yn = 1 -- Inspect the XML afterwards SELECT 'After' AS source,...