I am trying to create a Pivot table that will put the Years as the columns and use Price_Per_Unit as the aggregate. Below is the code I am using but I keep getting the following errorMsg 102, Level 15, State 1, Line 26Incorrect syntax near '2009'.SELECT *FROM(SELECT [DIVISION] ,[CPT] ,QTY ,CHG ,(CHG/QTY) AS PRICE_PER_UNIT ,[LOC] ,[NAME] ,[PRIFSC] ,[MOD1] ,[REF_LOC] ,[GRP] ,[CHARGE_TYPE] ,[MONTH] ,[YEAR] FROM [AdHoc].[dbo].[Charges_Per_Unit_2009_2010]) PPIVOT(SUM(PRICE_PER_UNIT)FOR YEAR IN (2009,2010))AS PVT
Brian