order by problem

Getting started with SSIS - Part 1: Introduction to SSIS

First Time? You can support us by signing up. It takes only 5 seconds. Click here to sign up. If you already have an account, click here to login.

Home | Ask Question

Ask in the public forum

Profile

Ask your questions in a public forum

My Blog Posts

Recent Blog Posts

Feb 25 2010 2:35AM |

SELECT COUNT(COURSEID) AS [COUNT], UPPER(DATENAME(MONTH,CONVERT(VARCHAR(50),DATEADD (MM, 0, STAMP),106)))
AS [MONTH]
,DATENAME(YY,STAMP) AS [MONTH]
FROM SESSIONSTATS
WHERE STAMP BETWEEN STAMP AND GETDATE() and datediff(mm,STAMP,GETDATE())<=4
GROUP BY DATENAME(MONTH,CONVERT(VARCHAR(50),DATEADD (MM, 0, STAMP),106)),DATENAME(YY,STAMP)
ORDER BY DATENAME(MONTH,CONVERT(VARCHAR(50),DATEADD (MM, 0, STAMP),106)) DESC

output of above query like this :

20356    OCTOBER    2009
18902    NOVEMBER    2009
11898    JANUARY    2010
20994    DECEMBER    2009

but I want to order like this

11898 JANUARY 2010

20994 DECEMBER 2009

18902 NOVEMBER 2009

20356 OCTOBER 2009

how can i achive this.?