dynamic crosstab / pivot tables in TSQL

read article:
Dynamic Cross-Tabs/Pivot Tables (SQLTeam.com)