Post reply

Updating multiple rows

  • July 2, 2014 at 10:38 am

    #309624

    I need to update a empty column in our SQL database with the login ID for employees of our company.

    The table is called SY01200 and were I need to put the login ID is column INET5, and the login ID is just me stripping off the company's email address(removing the @company.com), and I need to update the INET5 column only where Master_Type = 'EMP'

    So here is a screenshot of the table

    And here is the Query that I am using to strip the email select LEFT(convert(varchar(40),EmailToAddress),LEN(convert(varchar(40),EmailToAddress))-14) As LoginName from sy01200 where Master_Type = 'emp'

    And here is what I thought the Query would be to update however I got and error saying more than 1 arguement returned

    UPDATE sy01200

    SET INET5 = (select LEFT(convert(varchar(40),EmailToAddress),LEN(convert(varchar(40),EmailToAddress))-14) As LoginName from sy01200 where Master_Type = 'emp')

    WHERE Master_Type = 'EMP'

  • July 2, 2014 at 10:44 am

    #1726574

    Surely you just want to do this?

    UPDATE sy01200

    SET INET5 = LEFT(convert(varchar(40),EmailToAddress),LEN(convert(varchar(40),EmailToAddress))-14)

    WHERE Master_Type = 'EMP'

    John

  • July 2, 2014 at 11:08 am

    #1726587

    Perfect thank you! That makes more sense now lol

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply