suppressing namespace declarations in subqueries when using for xml
Posted on 2010-09-23
I 've created a sqlserver stored procedure to generate an xml file. I use " with xmlnamespaces" and have multiple nested "select for xml " statements. When the xml file is created, the namespace shows up for each nested query. What can I do in the stored procedure to eliminate the namespace in the subquery elements?