Click here to Skip to main content
15,901,001 members
Please Sign up or sign in to vote.
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
Comments
Rahul Rajat Singh 28-Jun-12 5:15am    
Could you please specify the criteria that you want to use for sorting.

1 solution

Go through Defining a Custom Order By Clause[^].
Another article[^] that uses a similar approach.
 
Share this answer
 
Comments
member60 28-Jun-12 7:19am    
ny 5!
Abhinav S 28-Jun-12 7:24am    
Thank you.

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



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900