ivan 26383 (10/8/2015)
If the xml data was stores in a table instead of a variable, how would the query look like?
this is where you would use CROSS APPLY
SELECT
...
FROM MyTable
CROSS APPLY XmlColumn('/root') t(c)
____________________________________________
Space, the final frontier? not any more...
All limits henceforth are self-imposed.
“libera tute vulgaris ex”