SQL Stored Proc - Order By Specific Values

Question

0.00/5 (No votes)

See more:

Hi all,

I need to order:

Cape Town Fred
Cape Town Joe
Cape Town Anna
Durban John
Durban Mary
Johannesburg Frank

To:

Durban John
Durban Mary
Johannesburg Frank
Cape Town Anna
Cape Town Fred
Cape Town Joe

Using a very simple, but accurate stored procedure.

PLEASE ANY HELP WOULD BE APPRICIATED!!

Posted 27-Jun-12 22:49pm

Ben Paxton

Add a Solution

Comments

Rahul Rajat Singh 28-Jun-12 5:15am

Could you please specify the criteria that you want to use for sorting.

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Abhinav S · Accepted Answer · 2012-06-27T23:15:00

Solution 1

Go through Defining a Custom Order By Clause[^].
Another article[^] that uses a similar approach.

Posted 27-Jun-12 23:15pm

Abhinav S

Comments

member60 28-Jun-12 7:19am

ny 5!

Abhinav S 28-Jun-12 7:24am

Thank you.