Post reply

Problem with update from another table

  • March 13, 2012 at 11:54 am

    #1458721

    This will work definitely Try this

    update VectorReplica.dbo.PARCELS

    set PARCEL_ID = A.new_pid

    from Ranieranneaxparcels A

    where VectorReplica.dbo.PARCELS.PARCEL_ID = A.NEW_PID

    or if output is 0 row affected than you need to consider where clause. It might be possible no any row is = to each other.

Viewing post 16 (of 15 total)

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