We help IT Professionals succeed at work.
Get Started

How to map SQL query results to a provided XSD file in SQL Server 2008 R2

220 Views
Last Modified: 2016-02-18
Hi Experts,

CASE:

I am running MS SQL SERVER 2008 R2.  I need to map my query results to a provided XSD file.  I did not create the XSD file and it does not look like the file was generated with my DB structure in mind.

QUESTIONS:

1. How can I map the results of my SQL query to this XSD ?
2. Are there any Visual Tools for accomplishing this task more easily?
3. Do I need to register/import this XSD file into my DB?
4. Do I have to do anything special in my SQL query (aside from actually composing it) to get the resulting XML to validate?
5. Can anyone point me to a small understandable example of this sort of process?


Any help is much appreciated.
Comment
Watch Question
Senior Developer
CERTIFIED EXPERT
Commented:
This problem has been solved!
Unlock 1 Answer and 2 Comments.
See Answer
Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

  • Troubleshooting
  • Research
  • Professional Opinions
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE