Ordering by month, show name

Question

Post reply

Ordering by month, show name

Steve Jones - SSC Editor

SSC Guru

Points: 736297
More actions
October 27, 2010 at 9:22 pm

#228558

A few people have requested a T-sqL article that talks about how to order a result set by the month number, but show the month name. So the result set would be
Jan
Feb
Mar
Feb
instead of
April
December
February
...

Viewing 9 posts - 1 through 8 (of 8 total)

You must be logged in to reply to this topic. Login to reply

Jeff Moden SSC Guru Points: 1004378 More actions · Answer 1

I'll take this one on.

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

Steve Jones - SSC Editor SSC Guru Points: 736297 More actions · Answer 2

Steve Jones - SSC Editor

SSC Guru

Points: 736297

October 27, 2010 at 9:40 pm

#1243302

Sold.

Jeff Moden SSC Guru Points: 1004378 More actions · Answer 3

Task complete. Submitted article via "Write For Us".

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

Grant Fritchey SSC Guru Points: 398890 More actions · Answer 4

Jeff Moden (10/28/2010)
Task complete. Submitted article via "Write For Us".

Over-achiever.

"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt

Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning

David Burrows SSC Guru Points: 65142 More actions · Answer 5

Grant Fritchey (10/28/2010)
Jeff Moden (10/28/2010)
Task complete. Submitted article via "Write For Us".
Over-achiever.

Meh! Jeff probably hasn't heard the saying 'Nobody likes a smart a$$' 😛

Far away is close at hand in the images of elsewhere.
Anon.

Jeff Moden SSC Guru Points: 1004378 More actions · Answer 6

David Burrows (10/28/2010)
Grant Fritchey (10/28/2010)
Jeff Moden (10/28/2010)
Task complete. Submitted article via "Write For Us".
Over-achiever.
Meh! Jeff probably hasn't heard the saying 'Nobody likes a smart a$$' 😛

BWAA-HAAA!!!! Smart as what? 😛

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

Jeff Moden SSC Guru Points: 1004378 More actions · Answer 7

Heh.., and I'm not the only one... I believe that Wayne S may have beat me in submitting the first article in this series.

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

SwePeso SSC-Dedicated Points: 39757 More actions · Answer 8

Bummer... Late for the party, again...

http://weblogs.sqlteam.com/peterl/archive/2009/03/18/A-general-approach-to-sort-different-dateformats-correctly.aspx

N 56°04'39.16"
E 12°55'05.25"