/*

--- CHECCK DIFF RECORDS

select cp.partymastid as cpid,cn.partymastid as cnid,cn.add1,cn.add2,cn.add3,cp.extcode ,
  CN.ADD1 AS CNADD1,CN.ADD2 AS CNADD2,CN.ADD3 AS CNADD3
 from partymast as cp  inner join 
 conversion_h.dbo.partymast  as cn
 on cp.extcode=cn.extcode and cp.extcode is not null
 and cp.villageid='PL_2_80_#H'
 WHERE CN.ADD1<>CP.ADD1 OR  CN.ADD2<>CP.ADD2 OR  CN.ADD3<>CP.ADD3

*/
Update PartyMast set PartyMast.Add1= uc.add1 ,PartyMast.add2=uc.add2,PartyMast.add3=uc.add3
from
(select cp.partymastid as cpid,cn.partymastid as cnid,cn.add1,cn.add2,cn.add3,cp.extcode 
 from partymast as cp  inner join 
 conversion_h.dbo.partymast  as cn
 on cp.extcode=cn.extcode and cp.extcode is not null
 and cp.villageid='PL_2_80_#H') as uc
 where partymast.partymastid=uc.cpid
 
Update PartyMastk set PartyMastk.Add1K= uc.add1k ,PartyMastk.add2k=uc.add2k,PartyMastk.add3k=uc.add3k
from
(
 select cp.partymastid as cpid,cn.partymastid as cnid,cnk.add1k,cnk.add2k,cnk.Add3K,cp.extcode 
 from partymastk 
 inner join partymast as cp  on partymastk.partymastid=cp.partymastid
 inner join  conversion_h.dbo.partymast  as cn on cp.extcode=cn.extcode and cp.extcode is not null  
 inner join  conversion_h.dbo.partymastk  as cnk on cnk.partymastid=cn.partymastid
 WHERE  cp.villageid='PL_2_80_#H' 
 ) as uc
 where PartyMastK.partymastid=uc.cpid


Update ADDRESS set ADDRESS.Add1= uc.add1 ,ADDRESS.add2=uc.add2,ADDRESS.add3=uc.add3
from
(select cP.partymastid as cPid,cP.add1,cP.add2,cP.add3 
 from partymast as cp WHERE cp.extcode is not null
 and cp.villageid='PL_2_80_#H') as uc
 where ADDRESS.partymastid=uc.cpid

 
Update ADDRESSK set AddressK.Add1K= uc.Add1K ,ADDRESSK.add2K=uc.add2K,ADDRESSK.add3K=uc.add3K
from
(select cP.partymastid as cPid,cPK.add1K,cPK.add2K,cPK.add3K 
 from partymast as cp INNER JOIN PartyMastK AS CPK ON CP.PartyMastId=CPK.PartyMastId
 WHERE cp.extcode is not null
 and cp.villageid='PL_2_80_#H') as uc
 where ADDRESSK.partymastid=uc.cpid