We had a requirement to generate some extract data in the form of XML. So while designing the solution, I had 2 options. 1. Use FOR XML in the Query with SQL 2005 2. Use regular SQL Queries and usign a Custom DataSet, serialize the data to XML. SQL 2005 has nice options to get the XML. You can assign name spaces to nodes, can have nested XMLs, can have custom Root and Child Xml node names. One example can be found here. http://www.wrox.com/WileyCD... But FOR XML queries are much...