Speeding up Cross Apply on XML

SQLServerCentral » Latest topics

Speeding up Cross Apply on XML

I am using Cross Apply to flatten an XML column that I have in a table. E.G.

ITEM
---------------------
ItemCode
XMLColors

The XMLColors column stores xml data about color variations. E.G.

more info...