My data contains both attribute and element-centric data, as well as multiple nested child nodes containing multiple child (grandchild) nodes.
But as usual the case, after hours of Googling, no one seems to want to address this topic on any level deeper than novice/beginner, so I again find myself addressing my question to the experts. :-)
Ok, using xml from a previous question, consider the following example:
I have an xml document that I am reading into sql server, in order to insert/update rows in an existing table.
The XML document might look like:
<Name Type="Professional">John Doe</Name>
<AddressLine>1234 Main St.</AddressLine>
<AddressLine>Anchorage, AK. 90049</AddressLine>
<AddressLine>5678 Frozen Tundra</AddressLine>
<AddressLine>Russian Vista Office Park, Igloo 2012</AddressLine>
<AddressLine>Anchorage, AK. 90051</AddressLine>
So, this document invloves two-levels of complexity:
1. Mixed-Mode data. i.e. Attribute-centric and Element-centric
2. Multiple nested child nodes containing multiple child nodes.
How would the "WITH" clause of the Openxml statement look for the