Transforming XML Data into Relational Datasets in SQL Server

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