Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

suppressing namespace declarations in subqueries when using for xml

Posted on 2010-09-23
5
Medium Priority
?
543 Views
Last Modified: 2012-08-13
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,

0
Comment
Question by:SAZ2
  • 3
  • 2
5 Comments
 
LVL 5

Expert Comment

by:rajaamirapu
ID: 33750749
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
0
 

Author Comment

by:SAZ2
ID: 33754072
Thank you for the response.  Will you please post the link?  Thanks
0
 
LVL 5

Accepted Solution

by:
rajaamirapu earned 2000 total points
ID: 33756045
0
 

Author Comment

by:SAZ2
ID: 33863924
Thank you all for the response.  I have gotten it to with the namespaces.  Thank you
0
 

Author Closing Comment

by:SAZ2
ID: 33863948
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.
0

Featured Post

Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

When we develop an application in Ms Access 2016 we should also try to protect the queries, macros and table links. I know I may not have a permanent solution but for novice users, they will not manage to break your application. Below is the detail …
A quick solution showing how to control and open a POS Cash Register Drawer using VBA with MS Access.
The viewer will learn how to create a normally distributed random variable in Excel, use a normal distribution to simulate the return on an investment over a period of years, Create a Monte Carlo simulation using a normal random variable, and calcul…
Do you want to know how to make a graph with Microsoft Access? First, create a query with the data for the chart. Then make a blank form and add a chart control. This video also shows how to change what data is displayed on the graph as well as form…

569 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question