内存对用友服务器的影响,用友U8 客户端运行软件后退出，服务器的内存无法释放，客户端比较多，所以内存越耗越大。...

用友U8 在查找收发存汇总表时，发现查7至7月份与1至7月份的期未数不一致，检查数据库，发现ST_TotalAccount中相同存货从4月份开始重复(只是金额不一致)，删除错误记录，查新查找数据正确。但由于存货有几千种，不可能一条条来删除，且需要计算才能分辨出错误记录。请集团编写语句帮忙来删除。用友U8 在查找收发存汇总表时，发现查7至7月份与1至7月份的期未数不一致，检查数据库，发现ST_TotalAccount中相同存货从4月份开始重复(只是金额不一致)，删除错误记录，查新查找数据正确。但由于存货有几千种，不可能一条条来删除，且需要计算才能分辨出错误记录。请集团编写语句帮忙来删除。

问题原因:ST_TotalAccount重复 解决方法:用以下语句删除错误记录：--4月份select cwhcode,cinvcode,sum(case when brdflag=1 then iquantity else -iquantity end) as quantity into sss from rdrecords a inner join rdrecord b on a.id=b.id where ddate sss.quantity where st_totalaccount.imonth=4drop table sss--5月份select cwhcode,cinvcode,sum(case when brdflag=1 then iquantity else -iquantity end) as quantity into sss from rdrecords a inner join rdrecord b on a.id=b.id where ddate sss.quantity where st_totalaccount.imonth=5drop table sss--6月份select cwhcode,cinvcode,sum(case when brdflag=1 then iquantity else -iquantity end) as quantity into sss from rdrecords a inner join rdrecord b on a.id=b.id where ddate sss.quantity where st_totalaccount.imonth=6drop table sss--7月份select cwhcode,cinvcode,sum(case when brdflag=1 then iquantity else -iquantity end) as quantity into sss from rdrecords a inner join rdrecord b on a.id=b.id where ddate sss.quantity where st_totalaccount.imonth=7drop table sss

解决方案：

问题原因:ST_TotalAccount重复 解决方法:用以下语句删除错误记录：--4月份select cwhcode,cinvcode,sum(case when brdflag=1 then iquantity else -iquantity end) as quantity into sss from rdrecords a inner join rdrecord b on a.id=b.id where ddate sss.quantity where st_totalaccount.imonth=4drop table sss--5月份select cwhcode,cinvcode,sum(case when brdflag=1 then iquantity else -iquantity end) as quantity into sss from rdrecords a inner join rdrecord b on a.id=b.id where ddate sss.quantity where st_totalaccount.imonth=5drop table sss--6月份select cwhcode,cinvcode,sum(case when brdflag=1 then iquantity else -iquantity end) as quantity into sss from rdrecords a inner join rdrecord b on a.id=b.id where ddate sss.quantity where st_totalaccount.imonth=6drop table sss--7月份select cwhcode,cinvcode,sum(case when brdflag=1 then iquantity else -iquantity end) as quantity into sss from rdrecords a inner join rdrecord b on a.id=b.id where ddate sss.quantity where st_totalaccount.imonth=7drop table sss