dynamic crosstab queries in TSQL (SQLMag.com)

read the article:
Dynamic Crosstab Queries (SQLMag.com)