Thanks for your reply. I'm looking at the SQL side of things, and would like 
this in a stored procedure, not in a .Net app...

Any ideas?
Cheers.
Dan.

"Martin Honnen" <mahotrash@y...> wrote in message 
news:eFU1WaVyHHA.1164@T......
> Daniel Bass wrote:
>
>> 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.
>
> The DataSet has a ReadXml method, if you simply read in that above XML 
> using that method then the DataSet instance has one table named Foo with 
> three columns Name, Area, and Interest.
>
>
>
> -- 
>
> Martin Honnen --- MVP XML
> http://JavaScript.FAQTs.com/