Sorting value in a column

Question

Sorting value in a column

Viewing 2 posts - 16 through 16 (of 16 total)

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

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

Ankur Bhardwaj (8/7/2008)
Hi Christopher,
what is the value of n..........
I am new to SQL Server.

Ankur,

Please see the following link for the answer to that question and, I'm sure, more that you will have when someone tells you what "n" is... 🙂

http://www.sqlservercentral.com/articles/TSQL/62867/

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

ChrisM@Work SSC Guru Points: 186127 More actions · Answer 2

Sergiy (8/7/2008)
Christopher Stobbs (8/7/2008)
ah Chris my bad,
I'm 2005, wierd that the results are different it must do with the Percent and Order by clause combination.
Ankur
What is your default collation?

Ours is Latin1_General_CI_AS

^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}

For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden