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

never heard of built-in function row_number? Expand / Collapse
Author
Message
Posted Monday, June 16, 2008 1:57 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Sunday, May 11, 2014 3:35 PM
Points: 18, Visits: 56
How valuable is an article from a db professional, who, three years after its release, never heard of the built-in function row_number()?
Post #517384
Posted Tuesday, June 17, 2008 6:50 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Friday, July 25, 2014 6:31 AM
Points: 2,656, Visits: 19,187
Something I think you'll find here is that even if you don't agree with an author, or you find an article to be somewhat less than helpful to your situation, the discussion surrounding the article typically proves to be useful. The collective experience and willingness to share information here is well worth any read.

That said, Steve et al are encouraging everyone to write articles, as much for their own education as for the group's enlightenment. They will not all be perfect, but if they teach one person something new, even if it's the author, they're worth the time taken to write and read.



---------------------------------------------------------
How best to post your question
How to post performance problems
Tally Table:What it is and how it replaces a loop

"stewsterl 80804 (10/16/2009)I guess when you stop and try to understand the solution provided you not only learn, but save yourself some headaches when you need to make any slight changes."
Post #518175
Posted Tuesday, June 17, 2008 11:25 PM


SSC-Dedicated

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

Group: General Forum Members
Last Login: Today @ 7:48 AM
Points: 36,759, Visits: 31,214
Very well said.

--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 #518758
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse