Create professional-looking Excels (Filters, Charts, Pivot Tables) with EPPlus
This tip is a brief introduction to Pivot operator in SQL Server
by Sifiso W Ndlovu
This tip illustrates a workaround to SQL Server pivoting on variable character data types.
A video that demonstrates OLAP for LightSwitch