lmnorms (4/3/2014)
Thank you. Adding in:Select '<?xml version="1.0"?>' + Cast((
[Original Select
]
) AS VARCHAR(MAX)) as XMLData
Worked nicely. Thank you for the information.
Warning: if you are used to clicking on the results and opening the xml into the formated view. It won't after this change. Because it puts in xml data format which behaves more like a string. Workaround Copy results or save to a file as xml. Then open up in a browser and walla, the view is like the node tree view.
Thank you again friends for your help. Happy SQL'ing to you.
Or CASTing it all back to XML should work, I would think.
If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.