Post reply

Error converting data type varchar to numeric

  • November 12, 2024 at 6:19 am

    #4480414

    issue resolved.

    • This topic was modified 3 weeks, 6 days ago by  water490.

  • November 12, 2024 at 7:47 am

    This was removed by the editor as SPAM

  • November 12, 2024 at 7:48 am

    This was removed by the editor as SPAM

  • November 12, 2024 at 7:48 am

    This was removed by the editor as SPAM

  • 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

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

Viewing 6 posts - 1 through 5 (of 5 total)

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