How to create an XML File from typed XML data stored in Multiple Rows and is referring to same XSD

10 pts.
Tags:
SQL Server 2008
XML
I want to create a single XML file from typed XML data stored in Multiple Rows and it is referring to a single XSD I want to use this XSD to find the position of the respective elements present in various rows. I am using SQL Server 2008 and I am using an XML Datatype field to store Nodes of XML
ASKED: September 9, 2012  5:36 PM
UPDATED: September 10, 2012  12:05 PM

Answer Wiki

Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Discuss This Question: 1  Reply

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • TomLiotta
    I am using an XML Datatype field to store Nodes of XML   You store the nodes? Why use the XSD to locate anything? How is the XSD related to rows?   You'll probably need to show samples of a few rows before anyone can make a guess.   Tom
    125,585 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following