PowerPivot with SQL Server 2008 R2 One of the prime-time features of Microsoft SQL Server 2008 R2 is provided by the “Project Gemini” technology known as PowerPivot for “Self Service BI”. Working with ...

SUM(CASE WHEN p.productcategory = 'Books' THEN smd.sales ELSE 0 END) AS Books, SUM(CASE WHEN p.productcategory = 'Clothing' THEN smd.sales ELSE 0 END) AS Clothing ...