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 8:35 pm

    #1592854

    Jeff Moden (3/3/2013)

    Heh... dang it. Roshan Joe beat me to it. You can, however, make it one notch simpler. Not sure which will be faster, though.

    UPDATE dbo.BigTable

    SET Software_Version_Raw = LEFT(Software_Version_Raw,CHARINDEX('.',Software_Version_Raw+'.')-1)+'.x'

    Seems like a real shame to lose all that version info, though. Seems like it would be better to add a calculated column to the table to do the N.x thing and keep the original information.

    Hey Jeff, I am nowhere near your talent and reputation... 🙂

    Thanks for showing a simpler way. The OP will be happy for this simpler solution.

    I this this will perform better since without the case statement.

    ----------------------------------------------------------------------------------------------------------------------------------------------------
    Roshan Joe

    Jeff Moden -Forum Etiquette: How to post data/code on a forum to get the best help[/url]