RE: Help with next date in SQL query

SSC Guru

Points: 1003894

May 30, 2013 at 10:44 am

#1619789

Tyekhan (5/30/2013)
Yes the num column is unique, but the best thing to use would be ID as the same records would have the same ID.
Jeff Moden (5/30/2013)
So, any feedback on my previous comment of...
Like I said, if the "Num" column is the wrong thing to consider to be unique, then we'll have to change a couple of indexes and a couple of column names.

WHICH ID? Certainly not the HistoryID, right?

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

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)