Quote Originally Posted by Arjay View Post
Well you've got different casing within the tags. Usually xml tags are pascal case (start with a capital letter) or camel case (start with a lower case letter). You can certainly have a mix but it's a bit odd.

As far as 'collection' element inside the 'Membership' element... that's okay, but the opening tag must exactly match the closing tag. You have <collection>...</Collection> and that isn't valid xml.
You're correct, I have made up the example but the actual data does follow the same concept that you outlined above. I originally shredded the XML in SQL but the unpredictability of the membership tag is painful to manipulate. Thanks for everything!