SELECT *
FROM
( SELECT year(OrderDAte) AS annee, Month(OrderDate) AS Mois, sum(SubTotal) as total
  FROM Sales.SalesOrderHeader
  GROUP BY year(OrderDAte), Month(OrderDate)
) AS src
PIVOT (SUM(total) FOR Annee IN ([2005],[2006],[2007],[2008]) ) as pvt
------------------------------------------
SET LANGUAGE French;
SELECT DATENAME(m, dateadd(month, mois - 1, 0)) as mois, [2005],[2006],[2007],[2008]
FROM
( SELECT year(OrderDAte) AS annee, Month(OrderDate) AS Mois, sum(SubTotal) as total
  FROM Sales.SalesOrderHeader
  GROUP BY year(OrderDAte), Month(OrderDate)
) AS src
PIVOT (SUM(total) FOR Annee IN ([2005],[2006],[2007],[2008]) ) as pvt