Newtoxml001 Posted August 7, 2019 Share Posted August 7, 2019 I am creating an XML file using SQL server using FOR xml path(''), TYPE) to create the structure. There is a section that combines single elements and repeating elements (details) within the same root. What I get is the single elements being repeated as many times for each repeating element. I need the output to look like the attached example. Is there a way to accomplish this? Thanks! Untitled.bmp Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now