Leaning how to manipulate XML in SQL Server 2005? You have to read
Jacob Sebastian’s XQuery Labs (http://www.sqlserverandxml.com/search/label/XQuery%20Lab)
Jacob has done a wonderful job compiling common how-to’s when working with SQLXML. Must read for anyone wanting to move faster with SQLXML.
Update (March 2009):
Jacob Sebastian has moved to : http://blog.beyondrelational.com/