SQL Server

[Njabulo]

Convert the following query to be pivoted, using PIVOT() .

SELECT CategoryID, AVG(UnitPrice)
FROM Products
GROUP BY CategoryID;

[nigelrivett]

see
http://www.nigelrivett.net/SQLTsql/Pivot_Statement.html