Greetings!
Give a column of XML datatype containing this:
<Foo>
<Name>Bob</Name>
<Area>Ghana</Area>
<Interest>Polar Hiking</Interest>
</Foo>
How do I write SQL that will produce a data set (DYNAMICALLY)?
Name Area Interest
-----------------------------
Bob Ghana Polar Hiking
The idea is that the name of the elements in my XML are untyped, and may
change. But I'd like a dynamic query to handle this mapping.
Thanks for your time.
Dan.
