Home Forums SQL Server 2014 Development - SQL Server 2014 Need unique number for groups of records RE: Need unique number for groups of records

  • August 25, 2014 at 1:31 pm

    #1740837

    Eirikur Eiriksson (8/25/2014)

    Lynn Pettis (8/25/2014)

    rwaring 96203 (8/25/2014)

    I am definitely no expert, but in my (25-year) career I see a big difference between those who write books about coding versus those of us in the trenches who actually have to make things work. Under pressure, with no time to luxuriate in the philosophy of Best Practices. Ms. Pettis' suggestion of Dense_Rank() solved my problem perfectly and it was easy and intuitive to use.

    <* cough *>

    rwaring 96203 (8/25/2014)

    I am definitely no expert, but in my (25-year) career I see a big difference between those who write books about coding versus those of us in the trenches who actually have to make things work. Under pressure, with no time to luxuriate in the philosophy of Best Practices. Ms. Mr. Pettis' suggestion of Dense_Rank() solved my problem perfectly and it was easy and intuitive to use.

    Got me kind of worried for a minute:w00t:

    😎

    Lynn's ex-military. If he's gonna cough, let him cough. But don't ask him to cough...

    [font="Arial"]Low-hanging fruit picker and defender of the moggies[/font]

    For better assistance in answering your questions, please read this[/url].

    Understanding and using APPLY, (I)[/url] and (II)[/url] Paul White[/url]

    Hidden RBAR: Triangular Joins[/url] / The "Numbers" or "Tally" Table: What it is and how it replaces a loop[/url] Jeff Moden[/url]