crosstab in sql?
Posted on 2002-07-11
I have this crosstab query in Access 2000, is it possible to duplicate a crosstab in SQL with a stored procedure?
TRANSFORM Sum(view3.TotalCount) AS SumOfTotalCount
SELECT view3.MakeID, view3.ModelID, Sum(view3.TotalCount) AS Total
GROUP BY view3.MakeID, view3.ModelID
ORDER BY view3.MakeID, view3.ModelID