Crosstab query 1

[grnzbra]

Does SQL Server have anything like the Access crosstab query?

 

[MatthewPeters]

Here is a cross tab query example from BOL.


This is the SELECT statement used to create the rotated results:

SELECT Year,
SUM(CASE Quarter WHEN 1 THEN Amount ELSE 0 END) AS Q1,
SUM(CASE Quarter WHEN 2 THEN Amount ELSE 0 END) AS Q2,
SUM(CASE Quarter WHEN 3 THEN Amount ELSE 0 END) AS Q3,
SUM(CASE Quarter WHEN 4 THEN Amount ELSE 0 END) AS Q4
FROM Northwind.dbo.Pivot
GROUP BY Year
GO


Look up cross-tab reports in BOL for more details.

Matt

 

[grnzbra]

Thank you.

I was trying to find it in BOL without the hyphen.