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.