Programming Stuff

Monthly Archives: September 2016

PIVOT in SQL Server – Correct Aggregated Results

This is my first time using PIVOT and something I learned was: projection ( SELECT) is essential for correct aggregated results. Here a sample using a Sales table (link to download script file at the bottom): Here a wrong way to do a PIVOT , here […]