Posts

Showing posts with the label SQL

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
Post a Comment
Read more

SQL Cleanup set field value in one table from another

-
update franchiseeTable set franchiseeTable .postal_code_territory_id= a.postal_code_territory_id from franchisee_zips z inner join postal_code_territory a on z.pid=a.tdg_pid
Post a Comment
Read more