DECLARE @BusinessDate DATETIME
SET @BusinessDate = '2015-12-11'
DELETE  dbo.Meal_OrderFoods
FROM    dbo.Meal_Bills AS b ,
        dbo.Meal_ArrangedTables AS a ,
        dbo.Meal_Meal_CaptainsOrders AS c ,
        dbo.Meal_OrderFoods AS o
WHERE   b.Id = a.BillId
        AND a.Id = c.ArrangedTableId
        AND c.Id = o.CaptainsOrderId
        AND b.BusinessDate = @BusinessDate
        
DELETE  dbo.Meal_Meal_CaptainsOrders4Suits
FROM    dbo.Meal_Bills AS b ,
        dbo.Meal_ArrangedTables AS a ,
        dbo.Meal_Meal_CaptainsOrders AS c ,
        dbo.Meal_Meal_CaptainsOrders4Suits AS o
WHERE   b.Id = a.BillId
        AND a.Id = c.ArrangedTableId
        AND c.Id = o.Meal_CaptainsOrderId
        AND b.BusinessDate = @BusinessDate
        
DELETE  dbo.Meal_Meal_CaptainsOrders
FROM    dbo.Meal_Bills AS b ,
        dbo.Meal_ArrangedTables AS a ,
        dbo.Meal_Meal_CaptainsOrders AS c
WHERE   b.Id = a.BillId
        AND a.Id = c.ArrangedTableId
        AND b.BusinessDate = @BusinessDate
        
DELETE  dbo.Meal_SerialNo
FROM    dbo.Meal_Bills AS b ,
        dbo.Meal_ArrangedTables AS a ,
        dbo.Meal_SerialNo AS c
WHERE   b.Id = a.BillId
        AND a.Id = c.ArrangedTableId
        AND b.BusinessDate = @BusinessDate
        
DELETE  dbo.Meal_ArrangedTables
FROM    dbo.Meal_Bills AS b ,
        dbo.Meal_ArrangedTables AS a
WHERE   b.Id = a.BillId
        AND b.BusinessDate = @BusinessDate

DELETE  dbo.Meal_PaymentList
FROM    dbo.Meal_Bills AS b ,
        dbo.Meal_PaymentList AS a
WHERE   b.Id = a.BillId
        AND b.BusinessDate = @BusinessDate
        
DELETE  dbo.Meal_BalanceSerialNo
FROM    dbo.Meal_Bills AS b ,
        dbo.Meal_BalanceSerialNo AS a
WHERE   b.Id = a.BillId
        AND b.BusinessDate = @BusinessDate
        
DELETE  dbo.Meal_Bills
WHERE   BusinessDate = @BusinessDate

DELETE  dbo.Meal_History_OrderFoods
FROM    dbo.Meal_History_Bills AS b ,
        dbo.Meal_History_ArrangedTables AS a ,
        dbo.Meal_History_Meal_CaptainsOrders AS c ,
        dbo.Meal_History_OrderFoods AS o
WHERE   b.Id = a.BillId
        AND a.Id = c.ArrangedTableId
        AND c.Id = o.CaptainsOrderId
        AND b.BusinessDate = @BusinessDate
        
DELETE  dbo.Meal_History_Meal_CaptainsOrders4Suits
FROM    dbo.Meal_History_Bills AS b ,
        dbo.Meal_History_ArrangedTables AS a ,
        dbo.Meal_History_Meal_CaptainsOrders AS c ,
        dbo.Meal_History_Meal_CaptainsOrders4Suits AS o
WHERE   b.Id = a.BillId
        AND a.Id = c.ArrangedTableId
        AND c.Id = o.Meal_CaptainsOrderId
        AND b.BusinessDate = @BusinessDate
        
DELETE  dbo.Meal_History_Meal_CaptainsOrders
FROM    dbo.Meal_History_Bills AS b ,
        dbo.Meal_History_ArrangedTables AS a ,
        dbo.Meal_History_Meal_CaptainsOrders AS c
WHERE   b.Id = a.BillId
        AND a.Id = c.ArrangedTableId
        AND b.BusinessDate = @BusinessDate
        
DELETE  dbo.Meal_History_SerialNo
FROM    dbo.Meal_History_Bills AS b ,
        dbo.Meal_History_ArrangedTables AS a ,
        dbo.Meal_History_SerialNo AS c
WHERE   b.Id = a.BillId
        AND a.Id = c.ArrangedTableId
        AND b.BusinessDate = @BusinessDate
        
DELETE  dbo.Meal_History_ArrangedTables
FROM    dbo.Meal_History_Bills AS b ,
        dbo.Meal_History_ArrangedTables AS a
WHERE   b.Id = a.BillId
        AND b.BusinessDate = @BusinessDate

DELETE  dbo.Meal_History_PaymentList
FROM    dbo.Meal_History_Bills AS b ,
        dbo.Meal_History_PaymentList AS a
WHERE   b.Id = a.BillId
        AND b.BusinessDate = @BusinessDate
        
DELETE  dbo.Meal_History_BalanceSerialNo
FROM    dbo.Meal_History_Bills AS b ,
        dbo.Meal_History_BalanceSerialNo AS a
WHERE   b.Id = a.BillId
        AND b.BusinessDate = @BusinessDate
        
DELETE  dbo.Meal_History_Bills
WHERE   BusinessDate = @BusinessDate

DELETE  dbo.Meal_DepartmentSaleCollections
WHERE   BusinessDate = @BusinessDate 
DELETE  dbo.Meal_FoodTypeSaleCollections
WHERE   BusinessDate = @BusinessDate 
DELETE  dbo.Meal_PaymentCollections
WHERE   BusinessDate = @BusinessDate 
DELETE  dbo.Meal_SundryCollections
WHERE   BusinessDate = @BusinessDate 
DELETE  dbo.Meal_FoodSaleCollections
WHERE   BusinessDate = @BusinessDate 
DELETE  dbo.Meal_ChargesCollections
WHERE   BusinessDate = @BusinessDate 
IF EXISTS ( SELECT  *
            FROM    dbo.sysobjects
            WHERE   id = OBJECT_ID(N'[dbo].[Meal_DerateCollections]')
                    AND OBJECTPROPERTY(id, N'IsUserTable') = 1 ) 
    DELETE  dbo.Meal_DerateCollections
    WHERE   BusinessDate = @BusinessDate 
IF EXISTS ( SELECT  *
            FROM    dbo.sysobjects
            WHERE   id = OBJECT_ID(N'[dbo].[Meal_SpeFoodSaleCollections]')
                    AND OBJECTPROPERTY(id, N'IsUserTable') = 1 ) 
    DELETE  dbo.Meal_SpeFoodSaleCollections
    WHERE   BusinessDate = @BusinessDate