• SQL 2005 includes the PIVOT keyword, which you can use in combination with SUMs and COUNTs and so on.