Need unique number for groups of records

• ChrisM@home

  SSC-Insane

  Points: 24260

  More actions

  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]

• Lynn Pettis

  SSC Guru

  Points: 442467

  More actions

  August 25, 2014 at 3:57 pm

  #1740878

  CELKO (8/25/2014)

  ---

  Quit making excuses for not being professional.

  I agree, try being a professional and stop bashing people over the proverbial head. Instead, try being an actual mentor to those less knowledgeable than you. Oh, sorry, you believe in the teaching method espoused by your wife.

  And please, spare us the stories, we've all heard them many times and can find them on many of the threads you have galloped through.