"FOR XML" clause return

[Guest_imported]

Dear all,

Using the FOR XML clause (e.g. "SELECT * FROM A FOR XML AUTO&quot results in all the xml code being crammed into 14 lines of text (10.000 records where queried) with information loss at the 'edges' of the lines as the too-long lines are being cut. Example result using the Query analyser on a test database of ~100 rows shown below. Does anyone know of a way to remedy this?

BTW during the installation of "xml for sql" some dll's failed to register... any ideas for this??

TIA

Frank


===========
97 rows returned resulting in ~15 (!) result fields (<Table1>..</Table1>)
-----------
<Table1><A>sadf </A><B>sdaf </B></Table1><Table1><A>asdf </A><B>sda </B></Table1><Table1><A>s </A><B>s </B></Table1><Table1><A>d </A><B>asd </B></Table1><Table1><A>asd </A><B>s </B></Table1><
Table1><Table1><A>d </A><B>asd </B></Table1><Table1><A>asd </A><B>s </B></Table1><Table1><A>as </A><B>d </B></Table1><Table1><A>asd </A><B>fasd </B></Table1><Table1><A>fasd </A><B>fa </B></T
</B></Table1><Table1><A>fasd </A><B>fa </B></Table1><Table1><A>sd </A><B>d </B></Table1><Table1><A>sdf </A><B>sdf </B></Table1><Table1><A>asdf </A><B>asd </B></Table1><Table1><A>f </A><B>dsf

 

[ColinM]

Might be this problem again:
thread183-95351