WITH cte AS (SELECT ID_Dipendente, ID_Timesheet, SUM(Ore) AS Ore FROM Timesheet GROUP BY ID_Dipendente, ID_Timesheet) SELECT ID_Dipendente, [01/2009] AS [Gennaio], [02/2009] AS [Febbraio], [03/2009] AS [Marzo], [04/2009] AS [Aprile], [05/2009] AS [Maggio], [06/2009] AS [Giugno], [07/2009] AS [Luglio], [08/2009] AS [Agosto], [09/2009] AS [Settembre], [10/2009] AS [Ottobre], [11/2009] AS [Novembre], [12/2009] AS [Dicembre] FROM cte PIVOT (SUM(Ore) FOR ID_Timesheet IN ( [01/2009], [02/2009], [03/2009], [04/2009], [05/2009], [06/2009], [07/2009], [08/2009], [09/2009], [10/2009], [11/2009], [12/2009])) AS pvt