I believe that you want the FOR XML EXPLICIT.
Please check the following examples:
http://www.sqlservercentral.com/articles/ADO/article4/516/
http://articles.sitepoint.com/article/data-as-xml-sql-server
Please let me know how you make out.
Thanks.
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/