XML whitespace problem

[jigen3]

hi there,
i have a problem that doesn't seem to be mentioned anywhere. when i output data to xml using the SELECT statement and FOR XML the results have no whitespace formatting (no returns, tabs). is there some sort of setting i have to adjust to make the xml output include whitespace? thx for reading and any replies.

jigen3

 

[nigelrivett]

The for xml clause just produces xml. If you want to have it formatted so that it's easily readable then try loading it into an xml editor.

======================================
Cursors are useful if you don't know sql.
DTS can be used in a similar way.
Beer is not cold and it isn't fizzy.