【速达软件】【速达5000】5系3.97批量删除采购开单从表重复项并合计到主表

5系3.97批量删除采购开单从表重复项并合计到主表
drop  table #tb2
select b.billid,b.goodsid,min(itemno) rid into #tb2 from P_Purchasedetail b 
group by b.billid,b.goodsid
--（所影响的行数为 381 行）
select * from #tb2

--delete from P_Purchasedetail where not exists 
select * from P_Purchasedetail where not exists 
(select #tb2.rid from #tb2 
where P_Purchasedetail.itemno=#tb2.rid 
and P_Purchasedetail.goodsid=#tb2.goodsid
and P_Purchasedetail.billid=#tb2.billid
 ) 
--（所影响的行数为 774 行）
（所影响的行数为 1155 行）

delete from P_Purchasedetail where not exists 
--select * from P_Purchasedetail where not exists 
(select #tb2.rid from #tb2 
where P_Purchasedetail.itemno=#tb2.rid 
and P_Purchasedetail.goodsid=#tb2.goodsid
and P_Purchasedetail.billid=#tb2.billid
 ) 

select * from  P_Purchase where billid =5
select * from  P_