I have created an xml file using osql command shell.
my query looks like this:
SELECT 1 AS Tag,
Null AS Parent,
From #products FOR XML EXPLICIT
file is created just fine but the tags or nodes break in the file therefore file is not well formatted and not readable to the browser.