Cart Cleanup 
---> **************************************************************************
---> This deletes ALL Empty Order before a date
---> *** Cascade delete ALL data from [dbo].[bvc_Order]
---> *** Cut and paste output into another window and execute ***
SET NOCOUNT ON
PRINT '---> [dbo].[bvc_Order] Level=1'
PRINT '------> [dbo].[bvc_LineItem] Level=2'
DELETE FROM [dbo].[bvc_LineItem]
FROM [dbo].[bvc_Order]
INNER JOIN [dbo].[bvc_LineItem]
ON [bvc_Order].[bvin] = [bvc_LineItem].[OrderBvin]
WHERE bvc_Order.IsPlaced='0' AND (bvc_Order.LastUpdated <= '2022-07-30 23:59:00')
PRINT '------> DELETE FROM [dbo].[bvc_LineItem] Rows Deleted: ' + CAST(@@ROWCOUNT AS VARCHAR)
PRINT '------> [dbo].[bvc_OrderCoupon] Level=2'
DELETE FROM [dbo].[bvc_OrderCoupon]
FROM [dbo].[bvc_Order]
INNER JOIN [dbo].[bvc_OrderCoupon]
ON [bvc_Order].[bvin] = [bvc_OrderCoupon].[OrderBvin]
WHERE bvc_Order.IsPlaced='0' AND (bvc_Order.LastUpdated <= '2022-07-30 23:59:00')
PRINT '------> DELETE FROM [dbo].[bvc_OrderCoupon] Rows Deleted: ' + CAST(@@ROWCOUNT AS VARCHAR)
PRINT '------> [dbo].[bvc_OrderNote] Level=2'
DELETE FROM [dbo].[bvc_OrderNote]
FROM [dbo].[bvc_Order]
INNER JOIN [dbo].[bvc_OrderNote]
ON [bvc_Order].[bvin] = [bvc_OrderNote].[OrderId]
WHERE bvc_Order.IsPlaced='0' AND (bvc_Order.LastUpdated <= '2022-07-30 23:59:00')
PRINT '------> DELETE FROM [dbo].[bvc_OrderNote] Rows Deleted: ' + CAST(@@ROWCOUNT AS VARCHAR)
PRINT '------> [dbo].[bvc_OrderPackage] Level=2'
DELETE FROM [dbo].bvc_OrderPackage
FROM [dbo].[bvc_Order]
INNER JOIN [dbo].bvc_OrderPackage
ON [bvc_Order].[bvin] = [bvc_OrderPackage].[OrderId]
WHERE bvc_Order.IsPlaced='0' AND (bvc_Order.LastUpdated <= '2022-07-30 23:59:00')
PRINT '------> DELETE FROM [dbo].[bvc_OrderPackage] Rows Deleted: ' + CAST(@@ROWCOUNT AS VARCHAR)
PRINT '---> [dbo].[bvc_Order] Level=1 TOP LEVEL PARENT TABLE'
DELETE FROM [dbo].[bvc_Order] WHERE bvc_Order.IsPlaced='0' AND (bvc_Order.LastUpdated <= '2022-07-30 23:59:00')
PRINT '---> DELETE FROM [dbo].[bvc_Order] Rows Deleted: ' + CAST(@@ROWCOUNT AS VARCHAR)
---> This deletes ALL Empty Order before a date
---> *** Cascade delete ALL data from [dbo].[bvc_Order]
---> *** Cut and paste output into another window and execute ***
SET NOCOUNT ON
PRINT '---> [dbo].[bvc_Order] Level=1'
PRINT '------> [dbo].[bvc_LineItem] Level=2'
DELETE FROM [dbo].[bvc_LineItem]
FROM [dbo].[bvc_Order]
INNER JOIN [dbo].[bvc_LineItem]
ON [bvc_Order].[bvin] = [bvc_LineItem].[OrderBvin]
WHERE bvc_Order.IsPlaced='0' AND (bvc_Order.LastUpdated <= '2022-07-30 23:59:00')
PRINT '------> DELETE FROM [dbo].[bvc_LineItem] Rows Deleted: ' + CAST(@@ROWCOUNT AS VARCHAR)
PRINT '------> [dbo].[bvc_OrderCoupon] Level=2'
DELETE FROM [dbo].[bvc_OrderCoupon]
FROM [dbo].[bvc_Order]
INNER JOIN [dbo].[bvc_OrderCoupon]
ON [bvc_Order].[bvin] = [bvc_OrderCoupon].[OrderBvin]
WHERE bvc_Order.IsPlaced='0' AND (bvc_Order.LastUpdated <= '2022-07-30 23:59:00')
PRINT '------> DELETE FROM [dbo].[bvc_OrderCoupon] Rows Deleted: ' + CAST(@@ROWCOUNT AS VARCHAR)
PRINT '------> [dbo].[bvc_OrderNote] Level=2'
DELETE FROM [dbo].[bvc_OrderNote]
FROM [dbo].[bvc_Order]
INNER JOIN [dbo].[bvc_OrderNote]
ON [bvc_Order].[bvin] = [bvc_OrderNote].[OrderId]
WHERE bvc_Order.IsPlaced='0' AND (bvc_Order.LastUpdated <= '2022-07-30 23:59:00')
PRINT '------> DELETE FROM [dbo].[bvc_OrderNote] Rows Deleted: ' + CAST(@@ROWCOUNT AS VARCHAR)
PRINT '------> [dbo].[bvc_OrderPackage] Level=2'
DELETE FROM [dbo].bvc_OrderPackage
FROM [dbo].[bvc_Order]
INNER JOIN [dbo].bvc_OrderPackage
ON [bvc_Order].[bvin] = [bvc_OrderPackage].[OrderId]
WHERE bvc_Order.IsPlaced='0' AND (bvc_Order.LastUpdated <= '2022-07-30 23:59:00')
PRINT '------> DELETE FROM [dbo].[bvc_OrderPackage] Rows Deleted: ' + CAST(@@ROWCOUNT AS VARCHAR)
PRINT '---> [dbo].[bvc_Order] Level=1 TOP LEVEL PARENT TABLE'
DELETE FROM [dbo].[bvc_Order] WHERE bvc_Order.IsPlaced='0' AND (bvc_Order.LastUpdated <= '2022-07-30 23:59:00')
PRINT '---> DELETE FROM [dbo].[bvc_Order] Rows Deleted: ' + CAST(@@ROWCOUNT AS VARCHAR)