user defined function

• solus

  Hall of Fame

  Points: 3495

  More actions

  March 3, 2011 at 9:51 am

  #1294118

  The function actually works if i run the query, but its highlighted in red in the query window of management studio

  'cannot find either column 'dbo' or the user defined function or aggregate 'dbo.fn_ParseNumChars', or the name is ambiguous.

  How can this function be improved ? any suggestions ?

• Paul White

  SSC Guru

  Points: 150467

  More actions

  March 3, 2011 at 10:10 am

  #1294131

  mwwheeler (3/3/2011)

  ---

  The function actually works if i run the query, but its highlighted in red in the query window of management studio 'cannot find either column 'dbo' or the user defined function or aggregate 'dbo.fn_ParseNumChars', or the name is ambiguous. How can this function be improved ? any suggestions ?

  Can you post the exact SELECT statement that causes the error please?

  Paul White
  SQLPerformance.com
  SQLkiwi blog
  @SQL_Kiwi

• Lynn Pettis

  SSC Guru

  Points: 442467

  More actions

  March 3, 2011 at 10:49 am

  #1294165

  SQLkiwi (3/3/2011)

  ---

  mwwheeler (3/3/2011)

  ---

  The function actually works if i run the query, but its highlighted in red in the query window of management studio 'cannot find either column 'dbo' or the user defined function or aggregate 'dbo.fn_ParseNumChars', or the name is ambiguous. How can this function be improved ? any suggestions ?

  Can you post the exact SELECT statement that causes the error please?

  Good luck. I've been asking for that from the beginning.

• Jeff Moden

  SSC Guru

  Points: 1004356

  More actions

  March 3, 2011 at 9:07 pm

  #1294431

  mwwheeler (2/28/2011)

  ---

  I basically wanted to use this function to make sure the contents can be safely converted to an integer and not cause an exception (if it contained a word). Is there a more efficient/safer way to do this ?

  There certainly is. Please see the following article...

  http://www.sqlservercentral.com/articles/IsNumeric/71512/

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