Generating an XML Sitemap for Multiple Products Using XQuery and SQL

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