Create XML Export File

[yeagly21]

Good Day All -

I am in the process of creating an xml file via a stored procedure and I am wondering what are some of the best methods to doing this. I currently have three main nodes of information Node A, Node B and Node C. Forgive me if the terminology is not correct.

What I am trying to do is write all of the data to one table containing an xml data type. The issue that I am running into is when I am trying to add data to the table I am receiving errors unless I have the appropriate tags set up in the data being imported. Ultimately the file needs to look like this:

Node A
Node B
Node C
/Node C
/Node B
/Node A

Each Node contains additional elements and Node A will appear only once but Node B and Node C can appear numerous times. I am able to load Node C data to a table with the xml data type as well as the other two Nodes however I have not been able to load the beginning of Node A, beginning of Node B, all of Node C without having Node B or Node A closed first.

Can someone please help with this? I am sure that you may have additional questions so feel free to shoot them to me and I will explain myself further.

Thanks

Yeagly