• Same cost, but no predefined values:

    SELECT [Month] = DATENAME(mm,SomeDateTime),

    Amount = SUM(SomeAmount)

    FROM #MyHead

    WHERE SomeDateTime >= '2010' AND SomeDateTime < '2011'

    GROUP BY DATENAME(mm,SomeDateTime), DATEPART(MM, SomeDateTime)

    ORDER BY DATEPART(MM, SomeDateTime)