Currently working on restructuring some google sitemaps for my client. Instead of the usual query, loop, output process for a ColdFusion XML manipulation based task, I decided to get SQL server to do the work for me. Using FOR XML AUTO, ELEMENTS at the bottom of my query, I can get SQL to return the results of my query in an XML format, return it and the rest is ColdFusion work. Take a look at some articles on this topic at ...
SQL Server 2000 Meets XML @ COLDFUSION DEVELOPER’S JOURNAL