In this article I am going to explain how to convert sql table data to different xml format using FOR XML PATH().
Read this post on webcodeexpert.com