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