Solved

suppressing namespace declarations in subqueries when using for xml

Posted on 2010-09-23
5
519 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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 500 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

The Eight Noble Truths of Backup and Recovery

How can IT departments tackle the challenges of a Big Data world? This white paper provides a roadmap to success and helps companies ensure that all their data is safe and secure, no matter if it resides on-premise with physical or virtual machines or in the cloud.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Delete table fields 3 44
sIMULTANEOUS USAGE ON NETWORK-ACCESS 2010-2013 7 69
Access creating new db - relationships 8 49
Getting the 7Z zip dll to work with MS Access 8 48
Technology opened people to different means of presenting information, but PowerPoint remains to be above competition. Know why PPT still works today.
Did you know that more than 4 billion data records have been recorded as lost or stolen since 2013? It was a staggering number brought to our attention during last week’s ManageEngine webinar, where attendees received a comprehensive look at the ma…
This is Part 3 in a 3-part series on Experts Exchange to discuss error handling in VBA code written for Excel. Part 1 of this series discussed basic error handling code using VBA. http://www.experts-exchange.com/videos/1478/Excel-Error-Handlin…
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

736 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