18
I have a stored procedure and the select statement is:
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)
this shows the sum total for every month But I need to order the result by month and year coz my result shown like:
April 2013
February 2013
January 2013
June 2013
March 2013
May 2013
What is the solution in such a case?