declare @i int
set @i=0;
while (@i<50)
begin
delete from XZFW_BANJIE where BANJIEOID in (select top 1 BANJIEOID from XZFW_BANJIE where SHOULIOID in( select shoulioid from xzfw_banjie a group by shoulioid having COUNT(*)>=2) )
set @i=@i+1;
end
declare @i int
set @i=0;
while (@i<50)
begin
delete from XZFW_BANJIE where BANJIEOID in (select top 1 BANJIEOID from XZFW_BANJIE where SHOULIOID in( select shoulioid from xzfw_banjie a group by shoulioid having COUNT(*)>=2) )
set @i=@i+1;
end