DECLARE @GroupTable TABLE (ParentID NVARCHAR(10),ChildeName NVARCHAR(255)) DECLARE @GroupXML AS XML SET @GroupXML= '<GroupA> <ParantNode Id="001"> <ChildNode Name ="AA"> </ChildNode> </ParantNode> <ParantNode Id="002"> <ChildNode Name ="BB"> </ChildNode> </ParantNode> </GroupA>' INSERT INTO @GroupTable (ParentID,ChildeName) SELECT ParentID,--Id of ParantNode of GroupA GroupXML.GX.value('@Name', 'NVARCHAR(50)') ChildName FROM @GroupXML.nodes('/GroupA/ParantNode/ChildNode') AS GroupXML(GX)
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)