I can't get this to work. When I open the XML file, it has > and < for the > and < signs. If I do a mass replace and close and open the file, it seems to be alright if I don't change anything.
As soon as I do my query and "FOR XML PATH" with the node name and just try to copy one node in, it won't keep it. It's like it resaves to it's last recollection of what the file was like before updating. I've updated the count as well to reflect 3 Aliases.