Home Forums SQL Server 2008 T-SQL (SS2K8) i want update the 2nd column based on first column: RE: i want update the 2nd column based on first column:

  • March 21, 2013 at 12:11 pm

    #1599521

    carlosaamaral (3/21/2013)

    Sean Lange (3/21/2013)

    carlosaamaral (3/21/2013)

    Logic ?

    MID=(CASE WHEN ID-100=0 THEN NULL

    ELSE ID-100 END

    )

    That would work on the example data but I doubt the real situation is that straight forward. The code that Jeff and I posted makes it dynamic.

    ok ... but sometimes the simple, we do not see ... Without data, it really is very, very complicated ...

    Absolutely agreed. It's just that some of us have been doing this so long that we've learned to anticipate various data "possibilites" and to bulletproof the code a bit.

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