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

Importing Fields in XML using SQL Not Working: A Deep Dive into XQuery and XSLT