<div>
After getting the namespace nodes, you could remove the namespace from the xml<br />
Exectue the stored procedure<br />
see this link,<br />
it has everthing about namespace<br />

</div>


After getting the namespace nodes, you could remove the namespace from the xml
Exectue the stored procedure
see this link,
it has everthing about namespace


<div>
Thank you for the response. &nbsp;Will you please post the link? &nbsp;Thanks
</div>


Thank you for the response.  Will you please post the link?  Thanks

<div>
Thank you all for the response. &nbsp;I have gotten it to with the namespaces. &nbsp;Thank you
</div>


Thank you all for the response.  I have gotten it to with the namespaces.  Thank you

<div>
Not sure how to grade. &nbsp;The program worked with all the imbedded namespaces, I thought it would not so I was trying to get rid of them. &nbsp; I appreciate the feedback none the less.
</div>


Not sure how to grade.  The program worked with all the imbedded namespaces, I thought it would not so I was trying to get rid of them.   I appreciate the feedback none the less.

<div>
<div class="content wysiwyg-content">
Hello,<br />
I 've created a sqlserver stored procedure to generate an xml file. &nbsp;I use &quot;&nbsp;with xmlnamespaces&quot; &nbsp;and have multiple nested &quot;select for xml &quot;&nbsp;statements. &nbsp; When the xml file is created, the namespace shows up for each nested query. &nbsp;What can I do in the stored procedure to eliminate the namespace in the subquery elements?<br />
<br />
Thank you, <br />
<br />

</div>
</div>


Hello,
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?

Thank you, 



suppressing namespace declarations in subqueries when using for xml

Most development for the Microsoft platform is done utilizing the technologies supported by the.NET framework. Other development is done using Visual Basic for Applications (VBA) for programs like Access, Excel, Word and Outlook, with PowerShell for scripting, or with SQL for large databases.

Microsoft Development

Microsoft applications include a variety of software programs, including development and digital authoring programs (Expression and Media Center), educational programs, Internet software, including Essentials, Skype and the Live family, anti-virus, productivity applications and suites like Office, Excel, Word, Outlook, Access and PowerPoint, video games and server applications such as Exchange, SharePoint, IIS and Virtual Server.

Microsoft Applications

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.