USE T18A001

DELETE FROM BILL_DETAIL WHERE LEN(BkSrNo)=6 AND BkSrNo>='000247' and BkSrNo<='000426'
DELETE FROM BILL_ITEM_DETAIL WHERE LEN(BkSrNo)=6 AND BkSrNo>='000247' and BkSrNo<='000426'
DELETE FROM BILL_ITEM_TAKA_DETAIL WHERE LEN(BkSrNo)=6 AND BkSrNo>='000247' and BkSrNo<='000426'
DELETE FROM BILL_ITEM_IF_TAKA_DETAIL WHERE LEN(BkSrNo)=6 AND BkSrNo>='000247' and BkSrNo<='000426'
DELETE FROM BILL_ITEM_GREY_TAKA_DETAIL WHERE LEN(BkSrNo)=6 AND BkSrNo>='000247' and BkSrNo<='000426'


DELETE FROM BILL_CHALLAN_DETAIL WHERE LEN(BkSrNo)=6 AND BkSrNo>='000247' and BkSrNo<='000426'