Conditional Pivot

Concepts: sqlPivotCrosstab

You have a tall table of monthly metrics. One row per (product, month) pair. Turn it into a wide table with one column per month. Most SQL engines have no PIVOT keyword. Desired output: The Pattern SUM vs. MAX How to Spot It Follow-Ups