Newtoxml001 0 Posted August 7, 2019 Report 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 Quote Link to post Share on other sites
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.