Home Forums SQL Server 2008 SQL Server Newbies can this update statement be made easier RE: can this update statement be made easier

  • March 3, 2013 at 9:23 pm

    #1592859

    alan_lynch (3/3/2013)

    ok guys I have gone with the case statement it seems to be working but I am getting quite a few columns with the value

    unknown.x in it even the the original has 10.6.1 or 8.1.4 etc

    could it be because of some problem with the original column

    I have software_version_raw set as (Varchar(max),null)

    I don't see how that's possible in SQL Server. "unknown" isn't something that SQL Server will populate on its own.

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