Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase «««1234»»

SQL Server Ranking Functions Expand / Collapse
Author
Message
Posted Tuesday, April 20, 2010 2:43 PM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Tuesday, September 16, 2014 7:35 AM
Points: 2,817, Visits: 2,563
I have seen Row number used in several occasions and always struggled to understand it. This article is very clear and practical. I expect to start using these functions soon. Thanks.
Post #907262
Posted Tuesday, April 20, 2010 7:20 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Wednesday, September 17, 2014 8:03 AM
Points: 167, Visits: 1,458
Good article.

I've become very fond or ROW_NUMBER() lately, it's an efficient way of doing what I need to do for a large report.
Post #907369
Posted Tuesday, April 20, 2010 11:27 PM
SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Wednesday, September 10, 2014 3:19 AM
Points: 5,375, Visits: 1,391
Very interesting article. I haven't used some of the fuctions, but I will try to use them now...


Post #907447
Posted Wednesday, April 21, 2010 5:46 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Friday, September 12, 2014 5:21 PM
Points: 2,262, Visits: 5,406
Wonderful article WayneS.. a great read.. taught me new things about Ranking... Thanks
Post #907640
Posted Thursday, April 22, 2010 10:00 AM
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Friday, September 26, 2014 12:02 PM
Points: 536, Visits: 767
Loved it! New features like ranking functions tend to be underutilized, since people prefer to stick with true and tried. Articles like this one, really clarify things and help us start using these features.


Post #908784
Posted Wednesday, June 9, 2010 4:57 PM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Monday, October 29, 2012 9:48 PM
Points: 57, Visits: 217
Great article. Well written. Thank you, sir.
Post #935045
Posted Wednesday, June 9, 2010 8:12 PM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: General Forum Members
Last Login: Yesterday @ 11:18 PM
Points: 35,267, Visits: 31,759
I'm a little late on the feedback after the formatting fix and I apologize for that. VERY nicely done, Wayne. This will help a lot of folks just getting into Windowing functions.

--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."

(play on words) "Just because you CAN do something in T-SQL, doesn't mean you SHOULDN'T." --22 Aug 2013

Helpful Links:
How to post code problems
How to post performance problems
Post #935096
Posted Tuesday, July 27, 2010 7:33 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Yesterday @ 4:57 PM
Points: 7,745, Visits: 9,493
Nice article, nice simple examples. Well done, Wayne.

Tom
Post #959381
Posted Tuesday, July 27, 2010 5:36 PM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Yesterday @ 3:11 PM
Points: 5,361, Visits: 8,924
Thanks Tom, I'm glad that you liked it.

Wayne
Microsoft Certified Master: SQL Server 2008
If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!
Links: For better assistance in answering your questions, How to ask a question, Performance Problems, Common date/time routines,
CROSS-TABS and PIVOT tables Part 1 & Part 2, Using APPLY Part 1 & Part 2, Splitting Delimited Strings
Post #959785
Posted Tuesday, November 23, 2010 3:55 PM


SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Saturday, September 27, 2014 3:14 PM
Points: 153, Visits: 590
THANK YOU for such an excellent clarification of something that is very confusing to newbies like myself. Exceptionally well done. Much appreciated!


"If I had been drinking out of that toilet, I might have been killed." -Ace Ventura
Post #1025564
« Prev Topic | Next Topic »

Add to briefcase «««1234»»

Permissions Expand / Collapse