Advanced XML Processing with SQL Server

You could format the results of a query into XML format by using the FOR XML keyword. However, most of the times the default formatting or structure may not be helpful for the specific purpose we are looking for.

Many times we would need more control over the way the XML is formatted or structured. I have a new article at SQLServerCentral, which explains how control the structure of the XML result and format it the way we wish.