Miles

ALTER PROCEDURE dbo.DeleteEmptyRolls
(@RawStockRef varchar)
AS DELETE FROM tab_stk_rawstock_rolls
WHERE     rollid IN
                          (SELECT     dbo.tab_stk_rawstock_rolls.rollid
                            FROM          dbo.tab_stk_rawstock_rolls INNER JOIN
                                                   dbo.tab_stk_rawstock_adjustmentsrolls ON dbo.tab_stk_rawstock_rolls.rollid = dbo.tab_stk_rawstock_adjustmentsrolls.roll_id INNER JOIN
                                                   dbo.tab_arc_gritems ON dbo.tab_stk_rawstock_rolls.grn_item_id = dbo.tab_arc_gritems.ITEM_ID INNER JOIN
                                                   dbo.tab_stk_purchase_items ON dbo.tab_arc_gritems.PURCHASE_ITEM_ID = dbo.tab_stk_purchase_items.ITEM_ID
                            WHERE      (dbo.tab_stk_rawstock_rolls.qty - dbo.tab_stk_rawstock_adjustmentsrolls.adjustment_quantity = 0) AND 
                                                   (dbo.tab_stk_purchase_items.RAW_STOCK_REF = @RawStockRef));
                          DELETE FROM tab_stk_rawstock_adjustmentsrolls
                           WHERE     roll_adjustment_id IN
                                                      (SELECT     dbo.tab_stk_rawstock_adjustmentsrolls.roll_adjustment_id
                                                        FROM          dbo.tab_stk_rawstock_rolls INNER JOIN
                                                                               dbo.tab_stk_rawstock_adjustmentsrolls ON 
                                                                               dbo.tab_stk_rawstock_rolls.rollid = dbo.tab_stk_rawstock_adjustmentsrolls.roll_id INNER JOIN
                                                                               dbo.tab_stk_gritems ON dbo.tab_stk_rawstock_rolls.grn_item_id = dbo.tab_stk_gritems.ITEM_ID INNER JOIN
                                                                               dbo.tab_stk_purchase_items ON dbo.tab_stk_gritems.PURCHASE_ITEM_ID = dbo.tab_stk_purchase_items.ITEM_ID
                                                        WHERE      (dbo.tab_stk_rawstock_rolls.qty - dbo.tab_stk_rawstock_adjustmentsrolls.adjustment_quantity = 0) AND 
                                                                               (dbo.tab_stk_purchase_items.RAW_STOCK_REF = @RawStockRef));