While moving some MS Access Queries to a SQL Server View, I realized that SQL Server handles pivots quite differently than Access. Unfortunately in SQL Server they aren’t so dynamic as in Access. Pivot in Access Quick example of Access: ID Name Date Cost GST 1 Gameboard 2010-01-01 10.00 1.50 Read More