delete data from transactions

delete data from transactions

delete from TRANSACTION_DETAILS_P where TR_SEQ_NO in(select TR_SEQ_NO from TRANSACTION_MASTER_P where ard_no='101101')

delete from TRANSACTION_MASTER_P where ard_no='101101'

delete from FAILED_TRANSACTIONS_TRAILER_P where TR_SEQ_NO in(select TR_SEQ_NO from FAILED_TRANSACTIONS_P where SHOP_NO	='101101')

delete from FAILED_TRANSACTIONS_P where SHOP_NO	='101101'

delete from STOCK_TRAILER_P where DN_SEQ_NO in(select DN_SEQ_NO from STOCK_HEADER_P where shop_no='101101')

delete from STOCK_HEADER_P where shop_no='101101'

delete from [dbo].[STOCK_INVENTORY_P] where shop_no='101101'

delete from [dbo].[Transaction_allotment_cycle] 

update  MEMBER_ENTITLEMENT set consumed=0
where card_no  in('01234567890','01234567891','09876543210')