hi supose i have the following XML var
declare @xml xml=
'<fruits>
<apple>
<color>red</color>
</apple>
<pear>
<color>green</color>
<shape>oval</shape>
</pear>
</fruits>'
How can i read node by node in order to rename each one with some value i have in some table.
Thank you!
...
Go to the complete details ...