how to convert vb function to sql function

• Jeff Moden

  SSC Guru

  Points: 1004591

  More actions

  December 15, 2008 at 11:58 pm

  #912956

  Understood and no problem.

  Did you try my function, yet?

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

• SwePeso

  SSC-Dedicated

  Points: 39757

  More actions

  December 16, 2008 at 12:42 am

  #912970

  Jeff Moden (12/15/2008)

  ---

  Damned nice try, Peter... thought you had it, but not quite...

  Thanks!

  I didn't give it too much effort. Just enough to get OP a direction.

  ---

  N 56°04'39.16"
  E 12°55'05.25"

• Jeff Moden

  SSC Guru

  Points: 1004591

  More actions

  December 23, 2008 at 6:15 pm

  #917181

  Jedi Master (12/15/2008)

  ---

  Well yes as I have to make sure that any user input is correctly validated. I can't afford to have null or errors from the function so I need to get the actual answer or 0.

  No feedback from you, yet. Did you try the function I wrote for you?

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