Paul Mauriello
asked on
How would I, in SQL XML Query, (XQuery) to clone/copy a node then update the cloned node's name?
I want to write a query in SQL which takes the Loading Area containing <areaName>WCMEX</areaName> Duplicate it out and name the newly created one WCMEX1. Does any one know how to do that?
for example i have this.
<root xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
<loadingAreas>
<LoadingArea>
<areaName>Antartic</areaNa me>
<portId>0021</portId>
<portName>Houston</portNam e>
</LoadingArea>
<LoadingArea>
<areaName>WCMEX</areaName>
<portId>0004</portId>
<portName>Manzanillo, Mexico</portName>
</LoadingArea>
</loadingAreas>
</root>
And want this
<root xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
<loadingAreas>
<LoadingArea>
<areaName>Antartic</areaNa me>
<portId>0021</portId>
<portName>Houston</portNam e>
</LoadingArea>
<LoadingArea>
<areaName>WCMEX</areaName>
<portId>0004</portId>
<portName>Manzanillo, Mexico</portName>
</LoadingArea>
<LoadingArea>
<areaName>WCMEX1</areaName >
<portId>0004</portId>
<portName>Manzanillo, Mexico</portName>
</LoadingArea>
</loadingAreas>
</root>
for example i have this.
<root xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
<loadingAreas>
<LoadingArea>
<areaName>Antartic</areaNa
<portId>0021</portId>
<portName>Houston</portNam
</LoadingArea>
<LoadingArea>
<areaName>WCMEX</areaName>
<portId>0004</portId>
<portName>Manzanillo, Mexico</portName>
</LoadingArea>
</loadingAreas>
</root>
And want this
<root xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
<loadingAreas>
<LoadingArea>
<areaName>Antartic</areaNa
<portId>0021</portId>
<portName>Houston</portNam
</LoadingArea>
<LoadingArea>
<areaName>WCMEX</areaName>
<portId>0004</portId>
<portName>Manzanillo, Mexico</portName>
</LoadingArea>
<LoadingArea>
<areaName>WCMEX1</areaName
<portId>0004</portId>
<portName>Manzanillo, Mexico</portName>
</LoadingArea>
</loadingAreas>
</root>
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER