Thank you Jacob. I now see why I was having trouble with this example. It will only work in SQL 2008 and is not supported in SQL 2005. Get this erroe in SQL 2005: XQuery: SQL type 'xml' is not supported in XQuery....

Looking for this result: <parentnode id="1" attribute1="a" attribute2="b" > <childnode parentid="1" att1="c" att2="d" /> <parentnode/> The child node will have an id that will link it to an id in the parent node. Both nodes will ...

I am wanting to combine or insert a node in an xml column into a node in another xml column. How can this be done with an update statement? DECLARE @aTable AS TABLE(ID VARCHAR (5), ParentXML XML, ChildXML XML) INSERT INTO @aTable ([ID], [ParentXML],[C...

I am wanting to combine or insert a node in an xml column into a node in another xml column. How can this be done with an update statement? DECLARE @aTable AS TABLE(ID VARCHAR (5), ParentXML XML, ChildXML XML) INSERT INTO @aTable ([ID], [Paren...