撤销7月份未核对单据恢复

declare @inventb_id_t varchar(40),
  @part_id_t varchar(40)

declare cur_delete_data cursor for
 select inventb_id, part_id
   from f_invent_bill_items_7月份未核对上的明细备份  f_items_7
   where f_items_7.part_id in (
    select part_id
     from f_part
     where partacctype_id = 'Z003')
open cur_delete_data
fetch cur_delete_data into @inventb_id_t, @part_id_t
while (@@fetch_status = 0)
begin
 delete from f_invent_bill_items
  where f_invent_bill_items.inventb_id = @inventb_id_t and f_invent_bill_items.part_id = @part_id_t
 fetch cur_delete_data into @inventb_id_t, @part_id_t
end
close cur_delete_data
deallocate cur_delete_data

declare cur_delete_data_2 cursor for
 select inventb_id
  from f_invent_bill_7月份未核对上的明细备份 f_7
  where f_7.part_id in (
   select part_id
    from f_part
    where partacctype_id = 'Z003')
open cur_delete_data_2
fetch cur_delete_data_2 into @inventb_id_t
while(@@fetch_status = 0)
begin
 delete from f_invent_bill
  where f_invent_bill.inventb_id = @inventb_id_t
 fetch cur_delete_data_2 into @inventb_id_t
end
close cur_delete_data_2
deallocate cur_delete_data_2