Understanding SQL 2005 PIVOT clause

http://geekswithblogs.net/lorint/archive/2006/08/04/87166.aspx