Moved to FOR XML PATH – Yet another shaping example using FOR XML PATH
Moved to FOR XML PATH - Generating an element having NULL value
moved to Another XML Shaping Example - using FOR XML PATH and EXPLICIT
Moved to FOR XML PATH - How to generate a Delimited String using FOR XML PATH?
Moved to http://beyondrelational.com/blogs/jacob/archive/2008/08/04/for-xml-path-how-to-remove-the-lt-row-gt-element-from-the-output-of-a-for-xml-path-query.aspx