Adding root node to SQL

[Amit Kumar G]

I have a sql where i need to add root node... Current SQL SELECT CategoryId,CategoryDesc FROM TB_CategoryMaster AS Category WHERE CategoryActive=0 ORDER BY CategoryDisplayOrder FOR XML AUTO, ELEMENTS, TYPE output : 1001Automobiles But i want 1001Automobiles any help?

[pmarfleet]

Are you using the SQLXML Managed Classes to fetch your data? If so, set the RootTag property of your SqlXmlCommand object to "root" before executing the query. Paul