How redirect SQL Sserver XML output?

[vikys]

I have to generate an XMl from a SQL Server 2000 table. Using the clause FOR
XML i can only send the result to screen or to file.

I want, instead, store the result, into a field column in another table.
There's a way i can do it without passing through a file (and OpenXML), but
storing the result directly into the field column?

tnks in advance

 

[aaron.kempf]

insert into mytable (myfield1, myfield2)
select myfield1, (select myfield2 for XML)
from my happy table