| 解决方案： |
1、固定资产统计表与汇总表不一致的问题：可以使用下面语句更新：
UPDATE fa_DeprTransactions
SET dblMonthValue = 0, dblPeriodValue = 0, dblDeprT0 = 0,
lDeprMonths0 = 0, lUsedMonths0 = 0, dblDeprT1 = 0, lDeprMonths1 = 0, lUsedMonths1 = 0,
dblDeprT2 = 0, lDeprMonths2 = 0, lUsedMonths2 = 0, dblDeprT3 = 0, lDeprMonths3 = 0,
lUsedMonths3 = 0, dblDeprT4 = 0, lDeprMonths4 = 0, lUsedMonths4 = 0, dblDeprT5 = 0,
lDeprMonths5 = 0, lUsedMonths5 = 0, dblDeprT6 = 0, lDeprMonths6 = 0, lUsedMonths6 = 0,
dblDeprT7 = 0, lDeprMonths7 = 0, lUsedMonths7 = 0, dblDeprT8 = 0, lDeprMonths8 = 0,
lUsedMonths8 = 0
WHERE (sCardNum = '00046')
2、而对于00185卡片，目前想要不再提就需要做资产减少，或累计折旧调整。 |