Here are a bunch of links explaining FOR XML. It covers some FOR XML EXPLICIT functionality and focuses on the new capabilities in SQL Server 2005.
- FOR XML EXPLICIT or the “Query from Hell“ in SQL Server 2005: A less likely encounter
- Moving FOR XML EXPLICIT to the new PATH mode:
[Note: this entry has been updated with link 3 on 2004-06-10]