KnowledgeHub
Questions
Tags
Users
Search
Alex Rivera
|
Logout
Edit Question
Title
Body
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?
Tags (comma-separated)
Save Edits
Cancel