Merry Christmas 2014

• Jeff Moden

  SSC Guru

  Points: 1004558

  More actions

  January 12, 2015 at 5:01 pm

  #1769680

  TomThomson (12/29/2014)

  ---

  Iwas Bornready (12/29/2014)

  ---

  I would never do it this way.

  I would.

  It's much more fun than messing about with strings as Hugo suggests, because it provides useful mental excercise; but of course I'm no longer responsible for any production SQL code, so I can get away with it - - half a dozen years ago I would have regarded as criminal obfuscation.

  Heh... it's ironic that you used two dashes in your explanation because that will make it so no obfuscation is present.

  SELECT correctformulahere --Calculate Christmas of Current Year

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

• Arno Kwetters

  Hall of Fame

  Points: 3869

  More actions

  June 11, 2015 at 1:15 am

  #1804583

  A lot of points for such an easy question

• r.preethi

  SSC Eights!

  Points: 870

  More actions

  July 8, 2015 at 5:57 am

  #1810905

  we don't understand the explanation.can u elaborate more