By the way... here's the next step in turning you from a newbie to an SQL monster... it's what I'll use tonight to solve your problem... heh... unless you beat me to it...
http://www.sqlservercentral.com/articles/Crosstab/65048/
... the author of that article is a pretty good guy, too! 😛
--Jeff Moden
Change is inevitable... Change for the better is not.