固定资产累计折旧重算表锁死

问题原因： 固定资产201408期累计折旧与本年累计折旧数据错误。

使用固定资产数据修复工具 或 执行数据重算SQL 表t_fa_famoncard锁死

SQL：--重算累计折旧，全寿命累计折旧
update t_fa_famoncard set (FAccuDepr,FAccuDeprAll)
=(select isnull(t_fa_famoncard.fdeprtterm,0)+isnull(mon.faccudepr,0),isnull(t_fa_famoncard.fdeprtterm,0)+isnull(mon.FAccuDeprAll,0)
from t_fa_famoncard mon
where mon.fcompanyid = (select fid from t_org_company where fnumber='10205')
and mon.ffaperiodid in (select fid from t_bd_period where fnumber=201501)
and mon.ffacurcardid=t_fa_famoncard.ffacurcardid and mon.fcompanyid=t_fa_famoncard.fcompanyid
) where ffaperiodid in (select fid from t_bd_period where fnumber=201502)
and fcompanyid = (select fid from t_org_company where fnumber='10205')
and ffacurcardid in (select mon.ffacurcardid
from t_fa_famoncard mon
where mon.fcompanyid = (select fid from t_org_company where fnumber='10205')
and mon.ffaperiodid in (select fid from t_bd_period where fnumber=201501) )

--重算已折旧期间，全年累计折旧
update t_Fa_Famoncard set fdeprtermcount=fdeprtermcount+1,faccudeprtyear=fdeprtterm+faccudeprtyear
where ffaperiodid in (select fid from t_bd_period where fnumber=201502)
and fcompanyid = (select fid from t_org_company where fnumber='10205')