Material for my MSDN WebCast "Making the Most of XQuery with SQL Server 2005"
You will be able to get the WebCast recording and copies of the slides from the MSDN website (registration required). My apologies for the interruption during the WebCast.
Here are the code snippets I used during my WebCast demo (please use in order and don't forget to follow the links to the estimated query plans):
And as always, the general small print disclaimer:
THIS CODE AND INFORMATION ARE PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND, EITHER EXPRESSED OR IMPLIED, INCLUDING BUT NOT LIMITED TO THE IMPLIED WARRANTIES OF MERCHANTABILITY AND/OR FITNESS FOR A PARTICULAR PURPOSE.