Create root node using FOR XML

[culshaja]

Hi,

I am trying to create a root node for my document when using for XML AUTO. I cannot use the following:

SELECT '<Root>'
SELECT .....
SELECT '</Root>'

This is because the DOMDocument will not read it from the stream and errors in visual basic. Can anyone shed some light on this?

Thanks,

James James Culshaw
jculshaw@miniaturereview.co.uk

http://www.miniaturereview.co.uk

http://www.brainbench.com/transcript.jsp?pid=193305