troubleshooting Question

Hi Experts,

I have the following query which works fine. I just need to figure out how to sort by Month order instead of having months sorted alphabetically. I'm sure there is a simple way to do this but I can't think of anything.

Appreciate your help

Query is:

SELECT DATENAME(MM,[SubmissionDate]) as MonthName

,DATEPART(YEAR,[SubmissionDate]) as YearName

,SUM(CASE R.BranchID WHEN 1 THEN 1 ELSE 0 END) Riyadh

,SUM(CASE R.BranchID WHEN 2 THEN 1 ELSE 0 END) Jeddah

,SUM(CASE R.BranchID WHEN 3 THEN 1 ELSE 0 END) Dammam

,SUM(CASE WHEN R.BranchID ='1' OR R.BranchID ='2' OR R.BranchID ='3' THEN 1 ELSE 0 END) as Total

FROM [STR].[dbo].[ILicensesRenewApplications]R

WHERE StatusID <> 1

Group by DATENAME(MM,[SubmissionDate]),DATEPART(YEAR,[SubmissionDate])

UNION

SELECT 'Sum' MonthName

,' ' YearName

,SUM(CASE R.BranchID WHEN 1 THEN 1 ELSE 0 END) Riyadh

,suM(CASE R.BranchID WHEN 2 THEN 1 ELSE 0 END) Jeddah

,SUM(CASE R.BranchID WHEN 3 THEN 1 ELSE 0 END) Dammam

,SUM(CASE WHEN R.BranchID ='1' OR R.BranchID ='2' OR R.BranchID ='3' THEN 1 ELSE 0 END) as Total

FROM [STR].[dbo].[ILicensesRenewApplications]R

WHERE StatusID <> 1

order by MonthName, YearName

I have the following query which works fine. I just need to figure out how to sort by Month order instead of having months sorted alphabetically. I'm sure there is a simple way to do this but I can't think of anything.

Appreciate your help

Query is:

SELECT DATENAME(MM,[SubmissionDat

,DATEPART(YEAR,[Submission

,SUM(CASE R.BranchID WHEN 1 THEN 1 ELSE 0 END) Riyadh

,SUM(CASE R.BranchID WHEN 2 THEN 1 ELSE 0 END) Jeddah

,SUM(CASE R.BranchID WHEN 3 THEN 1 ELSE 0 END) Dammam

,SUM(CASE WHEN R.BranchID ='1' OR R.BranchID ='2' OR R.BranchID ='3' THEN 1 ELSE 0 END) as Total

FROM [STR].[dbo].[ILicensesRene

WHERE StatusID <> 1

Group by DATENAME(MM,[SubmissionDat

UNION

SELECT 'Sum' MonthName

,' ' YearName

,SUM(CASE R.BranchID WHEN 1 THEN 1 ELSE 0 END) Riyadh

,suM(CASE R.BranchID WHEN 2 THEN 1 ELSE 0 END) Jeddah

,SUM(CASE R.BranchID WHEN 3 THEN 1 ELSE 0 END) Dammam

,SUM(CASE WHEN R.BranchID ='1' OR R.BranchID ='2' OR R.BranchID ='3' THEN 1 ELSE 0 END) as Total

FROM [STR].[dbo].[ILicensesRene

WHERE StatusID <> 1

order by MonthName, YearName

Join the community to see this answer!

Join our exclusive community to see this answer & millions of others.

Unlock 2 Answers and 24 Comments.

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert

See if this solution works for you by signing up for a 7 day free trial.

Unlock 2 Answers and 24 Comments.

Try for 7 days”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.