Query based on sorting based on month

Question

Post reply

Query based on sorting based on month

Viewing 5 posts - 1 through 6 (of 6 total)

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

Phil Parkin SSC Guru Points: 247183 More actions · Answer 1

Define 'properly'. It looks OK to me, unless you want to sort on the name of the month, rather than its ordinal.

Grant Fritchey SSC Guru Points: 399330 More actions · Answer 2

Yep, looks right to me too.

"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

Smash125 Hall of Fame Points: 3563 More actions · Answer 3

got it thanks for the clarification . I should have observed i am sorting based on year and month.

thanks hguys

Phil Parkin SSC Guru Points: 247183 More actions · Answer 4

Also, why not just use

ORDER BY BusinessEntityID, OrderDate

?

It might perform better.

Jeff Moden SSC Guru Points: 1004664 More actions · Answer 5

Phil Parkin wrote:

Also, why not just use
ORDER BY BusinessEntityID, OrderDate
?
It might perform better.

+1000

--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)