Update multiple columns from other Table via Join

 update franchisees
 set
 franchisees.posid=temp.POSID,
 franchisees.poskey=temp.[POS Key]
  from franchisees f
  inner join [Table_Two] temp on f.AccountCode=temp.AccountCode

Comments

Popular posts from this blog

Linq - Data Entities - Records by Max Date with CASE

Excel download with Jquery using Table

Linq Remove from list based on other table