Error converting data type varchar to numeric

Question

Error converting data type varchar to numeric

water490

Ten Centuries

Points: 1078
More actions
November 12, 2024 at 6:19 am

#4480414
issue resolved.
- This topic was modified 7 months, 1 week ago by water490.

Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

Grant Fritchey SSC Guru Points: 399061 More actions · Answer 1

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: 1004600 More actions · Answer 2

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)