Error converting data type varchar to numeric

• water490

  Ten Centuries

  Points: 1104

  More actions

  November 12, 2024 at 6:19 am

  #4480414

  issue resolved.

  • This topic was modified 8 months ago by water490.

• Grant Fritchey

  SSC Guru

  Points: 399143

  More actions

  November 12, 2024 at 12:59 pm

  #4480555

  Instead of removing the original question, you could have posted the solution so that if others hit it, they can benefit. Just a thought.

  "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
  - Theodore Roosevelt

  Author of:
  SQL Server Execution Plans
  SQL Server Query Performance Tuning

• Jeff Moden

  SSC Guru

  Points: 1004615

  More actions

  November 12, 2024 at 5:16 pm

  #4480675

  water490 wrote:

  issue resolved.

  It's a two way street... It would have been nice if you'd done like Grant suggested.

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