Thanks Greg. Peter's solution is working for me, but I appreciate the input.

When I tried your method I got an error. I realize I'm using SQL Server 2008 SSMS but I'm connecting to a 2005 database. Perhaps that has something to do with it...

Msg 325, Level 15, State 1, Line 22

Incorrect syntax near 'UNPIVOT'. You may need to set the compatibility level of the current database to a higher value to enable this feature. See help for the stored procedure sp_dbcmptlevel.