Post reply

Error message: "The multi-part identifier could not be bound."

  • September 28, 2012 at 4:51 am

    #1543320

    Try Like below:

    Update ContractData

    set ContractData.coreprocesstoken18 = udb.coreprocesstoken18

    FROM ContractData AS cd

    INNER JOIN

    (select accountnumber, sourcesystem, effectivedate, siccode, coreprocesstoken18

    from RR_GMC.RCA.dbo.UDBSourceData

    where sourcesystem = 'CAN'

    and effectivedate = '6/30/2012') as udb ON udb.accountnumber = cd.accountnumber

Viewing post 16 (of 15 total)

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