Extracting Specific Elements from an XML Document using XQuery in SQL Server 2005 or Later

Extracting Complex Nested XML into a Structured Table Using XQuery and SQL Server