Very cool concept ....

For all interested in performance aspect, XML data types are powerful but expensive. For XML queries, execution plan means very little. As the XML payload/ nodes...

Thanks guy .... tally table worked like a charm

I kept away from direct conversion because I was getting arithmetic overflow exceptions. I narrowed down to the following row, any ideas, how I can get past this. thanks in...

thanks. I've tried that as well, its a SQL 2005 XQuery limitation; accepts only string literals. Below is the error

The argument 1 of the xml data type method "query" must...

here you go,

select @x.query('distinct-values(for $a in //row/* return concat(local-name($a),","))')

Nevermind, figured out the comma part.

ryan,

the bo xml has about 450 columns, column names vary from 10 chars to 25 chars long. I fear I will not be able...

thanks Lynn.

is there anyway to make the above query return as a comma seperated list?

thanks

thanks. This definitely gives me a starting point.

also, I feel left out with FLOWR, are there any good online tutorials?

thanks for the response.

well, this kind of goes back to my quesiton; how would one write a generic XML column extracter?

thanks

awesome, that works. thanks.