I'm looking if it is possible to make query in T-SQL that will select value from every tag of my XML document.
I don't know how many tags there can be, and i don't know their names, because it should be dynamic... It is not important format of output (it can be manipulated later), only thing that is matter is that I get data from every tag :)
Thanks