商贸版凭证过账时提示名称或代码在系统中已经被使用

select * from t_itemdetail

exec sp_cleanitemdetailv

GO

update a set a.fdetailcount=b.Fcount

from  t_itemdetail  a  join  (select  Fdetailid,count(*)  as  Fcount  from  t_itemdetailv

where fitemid=-1 group by Fdetailid) b

on a.fdetailid=b.fdetailid  where a.fdetailcount<>b.Fcount

GO