• I'd just alter the Order By and call it good.

    ---------------------------------------------------------

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

    Amount = SUM(SomeAmount)

    FROM #MyHead

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

    GROUP BY DATENAME(mm,SomeDateTime)

    ORDER BY MAX(DATEPART(mm,SomeDateTime))