asked on 4/3/2013

TSQL - working with XML.

Hello,

I am writing a stored procedure that will return an xml document.

The document contains 3 sections.

I am thinking that i would first create the three different sections with their own TSQL and then combine them into the final xml document.

Is this OK? And if so how would i modify my xml document to insert the three sections between the root tags?

Using SQL Server 2008.

/Thanks

XML Microsoft SQL Server 2008 SQL

Last Comment

soozh

4/3/2013

Ioannis Paraskevopoulos

4/3/2013

Hi,

Can you post a sample table with data and the expected XML format?

Giannis

Deepak Lakkad

4/3/2013

Hi,

you can use FOR XML clause to generate XML

following link will be helpful for that

http://msdn.microsoft.com/en-us/library/ms178107.aspx

- Deepak Lakkad

soozh

4/3/2013

ASKER

Thanks for the link but i have already done my homework and i can produce the xml i need.

My question is if it is bad practice to generate the seperate sections and then join them in one xml document.

And if this is possible how would i do:

xmlDoc = xmlSection1 + xmlSection2 + xmlSection3

I.e. is there syntax/tools to work with xml appart from select/insert etc.

ASKER CERTIFIED SOLUTION

Ioannis Paraskevopoulos

4/3/2013

THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.

View this solution by signing up for a free trial.

Members can start a 7-Day free trial and enjoy unlimited access to the platform.

See Pricing Options

Start Free Trial

soozh

4/3/2013

ASKER

Thanks Giannis... that is exactly what i need.