Is there any way around the limitation of using the output of a select ... for xml in an insert statement inside SQL itself?
I realy need to do something like this:
Insert theTable(AField)
select stuff from anotherTable for XML auto
Any suggestions would also be welcome.
Rudolf