title: Order By month and year in sql with sum
body: <p>I have a stored procedure and the select statement is:</p>
  
  <pre><code>SELECT     { fn MONTHNAME(OrderDate) } AS MonthName, YEAR(OrderDate) AS Year, SUM(TotalValue) AS Profits
  FROM         [Order]
  WHERE     (YEAR(OrderDate) = @year)
  GROUP BY { fn MONTHNAME(OrderDate) }, YEAR(OrderDate)
  </code></pre>
  
  <p>this shows the sum total for every month 
  But I need to order the result by month and year coz my result shown like:</p>
  
  <pre><code>April 2013 
  February 2013 
  January 2013 
  June 2013 
  March 2013 
  May 2013 
  </code></pre>
  
  <p>What is the solution in such a case?</p>