通过从另一个表获取数据来更新列

直进与除法连接

select 
t1.Code
,t1.[APAC APACRatio] / t2.[Count]
,t1.[EMA EMEARatio] / t2.[Count]
from table 1 t1
inner join table2 t2 on t1.Code = t2.Code

或者,可能是串联?

select 
t1.Code
,concat(t1.[APAC APACRatio],'/',t2.[Count])
,concat(t1.[EMA EMEARatio],'/',t2.[Count])
from table 1 t1
inner join table2 t2 on t1.Code = t2.Code

因此,

update t1
    set 
     t1.[APAC APACRatio] =  concat(t1.[APAC APACRatio],'/',t2.[Count])
    ,t1.[EMA EMEARatio] = concat(t1.[EMA EMEARatio],'/',t2.[Count])
    from table1 t1
    inner join table2 t2 on t1.Code = t2.Code