Sahil just posted a nice little primer for getting started with the FOR XML clause in sql 2005 . Good start, however I feel like he missed a technique. One of my major gripes with working with FOR XML is when you have to join more than 2 tables in your query. FOR XML AUTO tends to create a child node...