-- 变更单冗余资产编码字段，用于引出，此处升级历史数据
update  t_fa_changefieldentry AS A set FASSETNUMBER = (select isnull(fnumber,' ') from t_fa_card_real where A.frealcardid = t_fa_card_real.fid) where fassetnumber = ' ' and exists (select 1 from t_fa_card_real r where r.fid=A.frealcardid);