Home Forums Article Discussions Article Discussions by Author Discuss Content Posted by Jeff Moden Sorting Months By Number (SQL Spackle) RE: Sorting Months By Number (SQL Spackle)

  • August 7, 2013 at 3:25 pm

    #1639573

    aobermueller (8/7/2013)

    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))

    Not sure what MAX will do to performance. You might want to test it using the test harness I posted a couple of posts back.

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)