How to lay out SQL Code

• Jeff Moden

  SSC Guru

  Points: 1004405

  More actions

  March 10, 2008 at 3:14 pm

  #787630

  OK, then move on to one that does interest you

  Whether I agree or not, it's still interesting and dialog about such subjects are one way for folks to exchange ideas and maybe learn something new.

  I do very much agree that some standard in a shop must be followed just for the sake of consistency which has the effect of error reduction all by iteself because people usually have to look at their own code more than once just to make sure it will pass formatting standards during a code review.

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