Home Forums SQL Server 2005 Development Convert alphanumeric to BigInt RE: Convert alphanumeric to BigInt

  • March 24, 2009 at 4:29 pm

    #965709

    jchandramouli (3/23/2009)

    Jeff,

    I have used your script both in UDF and as a query. But the problem is when the table records exceeds 10000, there is a performance issue. It takes more than two mins.

    I check it when I get home from work tonight. Thanks for the feedback.

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