The error i'm getting when building the output XML is this:
"Parent tag ID 2 is not among the open tags. FOR XML EXPLICIT requires parent tags to be opened first. Check the ordering of the result set."
I'm looking to generated this type of output
<RootNode>
<Header>
<Footer>
</RootNode>...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.