update vs4tar set tarncontactname=''+(select top 1 tarcfirstname from vs4tarcontact where tarctarncode=tarncode order by tarcstatus desc)
update vs4tap set tapncontactname=''+(select top 1 tapcfirstname from vs4tapcontact where tapctapncode=tapncode order by tapcstatus desc)