Newtoxml001 0 Report post 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 Share this post Link to post Share on other sites
