I have created an xml file using osql command shell.
my query looks like this:
SELECT 1 AS Tag,
Null AS Parent,
iosc [product!1!iosc!Element],
ST [product!1!ST!Element],
nm_id [product!1!nm_id!Element],
fly [product!1!fly!Element]
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.

any ideas???
thanks,
IK