Home Forums SQL Server 2016 SQL Server 2016 - Development and T-SQL Update the first and last 2 charactors with year and month RE: Update the first and last 2 charactors with year and month

  • February 26, 2018 at 12:29 pm

    #1981172

    Oops, correction:


    UPDATE [EC_StoreAttributes]

      SET AttributeValue = CONVERT(varchar(2), GETDATE(), 12) -- 112)112) + /* 12 rather than 112 */
       SUBSTRING(AttributeValue, 3, LEN(AttributeValue) - 4) +
       CONVERT(varchar(2), GETDATE(), 3)

    WHERE
    AttributeType = 'ECSRCCODE' and StoreRecordId = '1'

    SQL DBA,SQL Server MVP(07, 08, 09) A socialist is someone who will give you the shirt off *someone else's* back.