All, i have been serarching the internet to find the latest and greatest
way to parse through XML code using SQL Server 2008 R2. Using openrowset and bulk is not an option for me.
Please can someone provide me with the latest and greatest way to parse through xml code usnig SQL server 2008 R2. The XML file that needs to be parsed is attached.