There's an article somewhere on the site about using CROSS TAB queries instead of pivots. Search the Articles portion of this site...
Steve is referring to following articles written by Jeff Moden
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs