固定资产：该数据有错或被其他用户删除,请刷新后重试!分享方法

从标准版升级到的15.0账套
固定资产变动/清理：该数据有错或被其他用户删除,请刷新后重试!

数据库查询很多相同记录，删除FAlterID 最大值，保留最小值之后 固定资产还是无法变动

求高手解惑~~等了很久，然并卵！
自己搞研究搞，分享方法：
----------删除相同记录ID最大号的卡片和变动记录--------------------------

select FAlterID into ##bear9527
from t_FACard
where FAlterID in
(
select FAlterID from T_FACARD where
FAssetNumber in (select FAssetNumber from T_FACARD group by FAssetNumber having count(FAssetNumber)>1)
and FAlterID in (select max(FAlterID) from T_FACARD group by FAssetNumber having count(FAssetNumber)>1)
)

delete from t_FACard where FAlterID in (select FAlterID from ##bear9527)
delete from t_FAClear where FAlterID in (select FAlterID from ##bear9527)
delete from t_FADevice where FAlterID in (select FAlterID from ##bear9527)
delete from t_FACardItem where FAlterID in (select FAlterID from ##bear9527)
delete from t_FADept where FAlterID in (select FAlterID from ##bear9527)
delete from t_FAExpense where FAlterID in (select FAlterID from ##bear9527)
delete from t_FAVoucher where FAlterID in (select FAlterID from ##bear9527)
delete from t_FAOrgFor where FAlterID in (select FAlterID from ##bear9527)
delete from t_FAPurchase where FAlterID in (select FAlterID from ##bear9527)
delete from t_faalter where FAlterID in (select FAlterID from ##bear9527)
drop table ##bear9527
go

仅供参考，执行代码前，请备份账套，出现问题与本人无关哈！