I have a sql data need to export to xml file; I can get data in xml mode using FOR XML PATH query and results are shown in xml style. When i click on xml link its opening in new tab with xml format exactly what i need.
But the problem is, i need to export that xml result into .xml file on my system. I tried by using "Results to file" option but unable to get what i need. Also i do not have bcp exceute permissions.
Can anyone please suggest me how to export those results to .xml file.
Thanks in advance!