How do I aggregate on more than one column within a PIVOT

On SQL Server pivot query using UNION ALL of two pivot queries multiple aggregations can be implemented easily.

Please check http://ift.tt/1A3wCZc

---

SQL Server, SQL Server 2012 Denali and T-SQL Tutorials