title: MS-SQL sort output in descending order
body: <p>I have this MS-SQL query with thousands of row records in database:<br /></p>
  
  <pre><code>SELECT DISTINCT TOP 7 DATENAME(MM, mydatetime) + ' ' + CAST(DAY(mydatetime) AS VARCHAR(2)) as thedate
      , MONTH(mydatetime)
      , DAY(mydatetime)
      , COUNT(Page) as totalcount
      , count(DISTINCT Page) as visitors
    FROM someTable
    WHERE Page LIKE '%AEC%'
    GROUP BY DATENAME(MM, mydatetime) + ' ' + CAST(DAY(mydatetime) AS VARCHAR(2))
      , MONTH(mydatetime)
      , DAY(mydatetime)
    ORDER BY MONTH(mydatetime) DESC
      , DAY(mydatetime) DESC
  </code></pre>
  
  <p>It will output this:<br/></p>
  
  <pre><code>thedate     | totalcount | visitors
  -----------------------------------
  October 17  |     4      |    1
  October 15  |     1      |    1
  October 12  |     1      |    1
  October 3   |     3      |    3
  October 2   |     42     |    22
  September 28|     2      |    1
  September 21|     14     |    10
  </code></pre>
  
  <p>My problem is that I simply cant output this in descending order so it will look like this:</p>
  
  <pre><code>thedate     | totalcount | visitors
  -----------------------------------
  September 21|     14     |    10
  September 28|     2      |    1
  October 2   |     42     |    22
  October 3   |     3      |    3
  October 12  |     1      |    1
  October 15  |     1      |    1
  October 17  |     4      |    1
  </code></pre>
  
  <p>So any help is greatly appreciated. </p>