Update in same table

update tempadd
  set ContactName =  x.ContactNAme
  from ( SELECT AddressID , ContactNAme From tempadd )x
  WHERE tempadd.AddressID=1 and x.AddressID=14

       
       
        UPDATE ra
SET ra.ContactName = rb.AddressLine1
FROM dbo.tempadd ra
INNER JOIN  dbo.tempadd rb
ON ra.AddressID = rb.AddressID
WHERE  rb.AddressID = 15