Updating a column with serial numbers

• Jeff Moden

  SSC Guru

  Points: 1000539

  More actions

  April 30, 2018 at 11:57 am

  #1988679

  jcelko212 32090 - Monday, April 30, 2018 11:10 AM

  So there's no such thing as a first row, second row, etc.

  There is if you declare it to be so and you use an ORDER BY.  No real difference between that and using a SEQUENCE except that a SEQUENCE would allow gaps on a rollback.

  --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)
  Intro to Tally Tables and Functions

• December 4, 2018 at 10:44 pm

  This was removed by the editor as SPAM

• December 4, 2018 at 10:46 pm

  This was removed by the editor as SPAM