You will want to read up on the FOR XML command in SQL Server. This will take the recordset that you create and turn it into an XML document.
FOR XML AUTO</pre>
You can find more information in Books OnLine or in the tip <a href="http://searchsqlserver.techtarget.com/tip/0,289483,sid87_gci1265579,00.html">T-SQL commands vs. XML AUTO in SQL Server</a>.
Last Wiki Answer Submitted: August 7, 2008 8:08 am by Denny Cherry64,520 pts.