Transformation Pattern with SQL, XML and CROSS APPLY
You don’t have to live with the repeated pain of transforming xml to rowset values when you need data from xml data stores. You also don’t need to transform and copy the data to relational database tables in MS SQL Server… (READ MORE)