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 11:19 am

    #1599497

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