SQL Server Update: "Using CASE Expressions" - Craig S. Mullins

Each SELECT in the UNION returns a distinct result set. You can see ... SUM( CASE mnth WHEN 1 THEN sales ELSE NULL END) AS jan, SUM(CASE mnth ...

www.craigsmullins.com