title: Ordering of month/year pairs in T-SQL query
body: <p>I am writing a stored procedure for displaying month and year. It is working, but it is not returning the rows in the desired order.</p>
  
  <pre><code>ALTER procedure [dbo].[audioblog_getarchivedates]  
  as  
  begin  
  select DateName(Month,a.createddate) + ' ' + DateName(Year,a.createddate) as ArchiveDate 
  from audio_blog a 
  group by DateName(Month,a.createddate) + ' ' + DateName(Year,a.createddate) 
  order by DateName(Month,a.createddate) + ' ' + DateName(Year,a.createddate) desc
  end
  </code></pre>
  
  <p>Results will come like this:</p>
  
  <blockquote>
    <p>March 2010<br>
    January 2010<br>
    February 2010 </p>
  </blockquote>
  
  <p>But that is not in a order (desc).</p>