| 解决方案： |
经查用户数据错误是由于fa_total和fa_DeprTransactions存在异常记录造成的；
select sum(dblDepr) , sum(dblDeprTotal),sum(dblMonthDeprTotal),sum(dblValue),sum(dblAccrualValue)
from fa_total
where iperiod=12
update fa_total set dblValue=0,dblDepr=0,dblDeprTotal=0
where iperiod=1
select sum(dblDepr),sum(dblDeprTotal),sum(dblValue),
sum(dblMonthDeprTotal+dblTransInDeprTotal+dblDepr-dblTransOutDeprTotal),
sum(dblMonthValue+dblAddValue-dblDecValue)
from fa_total
where iperiod=1
select sum(dblDepr1) ,sum(dblDeprT1) from fa_DeprTransactions
select sum(dbldepr),sum(dblBalanceValue),sum(dblDeprt) from aatjb where iperiod=1
select sum(dblDepr12) ,sum(dblDeprT12) from fa_DeprTransactions
--select sum(dblThisMonthValue) ,sum(dblMonthValue12) from fa_DeprTransactions
select sum(dbldepr),sum(dblBalanceValue) from aatjb
where iPeriod=12
|