use T21N001

INSERT INTO RECEIVED_RETURN_GOODS_DETAIL SELECT '7'+RIGHT(BkSrNo,4), BkAccCode, BkGRAmt, BkGRDate, BkRemark, BkCurDate, BkCurTime, BkUName, TransName, TransLRNo, TransLRCase, TransLRDate, TransFromStation, Haste, CreditNoteNo, SaleRtnType, GSTSupplyType, RefBillNo, RefBillDate, SMAccCode, EInvActNo, EInvActDate, EInvIRN, EInvQRCode, EWayNo FROM RECEIVED_RETURN_GOODS_DETAIL WHERE LEFT(BkSrNo,1)= '0' AND LEN(BkSrNo)=5
INSERT INTO RECEIVED_RETURN_GOODS_ADDLESS_DETAIL SELECT '7'+RIGHT(BkSrNo,4), BkBillNo, BkBillGRAmt, BkStatus, BkDescription, ISrNo, AdjGST, AdjGSTPerc FROM RECEIVED_RETURN_GOODS_ADDLESS_DETAIL WHERE LEFT(BkSrNo,1)= '0' AND LEN(BkSrNo)=5
INSERT INTO RECEIVED_RETURN_GOODS_ITEM_DETAIL SELECT '7'+RIGHT(BkSrNo,4), BkItemName, BkCut, BkPcs, BkMts, BkPer, BkRate, BkBillGRAmt, DesignScreen, ISrNo, PurSrNo, PurISrNo, PurRate, PurAmt, SubScreen, Fold, WOFoldMts, Barcode, SaleMRP, SaleDiscPerc, HSNCode, IGSTPerc, IGSTAmt, CGSTPerc, CGSTAmt, SGSTPerc, SGSTAmt, UTGSTPerc, UTGSTAmt, CESSPerc, CESSAmt, ItemDiscPerc, ItemDiscAmt, ItemAddPerc, ItemAddAmt, AddLess1Name, AddLess1Perc, AddLess1Amt, AddLess2Name, AddLess2Perc, AddLess2Amt FROM RECEIVED_RETURN_GOODS_ITEM_DETAIL WHERE LEFT(BkSrNo,1)= '0' AND LEN(BkSrNo)=5
INSERT INTO RECEIVED_RETURN_GOODS_TAKA_DETAIL SELECT '7'+RIGHT(BkSrNo,4), ItemSrNo, ISrNo, ItemSet, ItemQty, ItemTotal, ShadeNo FROM RECEIVED_RETURN_GOODS_TAKA_DETAIL WHERE LEFT(BkSrNo,1)= '0' AND LEN(BkSrNo)=5


DELETE FROM RECEIVED_RETURN_GOODS_ADDLESS_DETAIL WHERE LEFT(BkSrNo,1)= '0' AND LEN(BkSrNo)=5
DELETE FROM RECEIVED_RETURN_GOODS_ITEM_DETAIL WHERE LEFT(BkSrNo,1)= '0' AND LEN(BkSrNo)=5
DELETE FROM RECEIVED_RETURN_GOODS_TAKA_DETAIL WHERE LEFT(BkSrNo,1)= '0' AND LEN(BkSrNo)=5
DELETE FROM RECEIVED_RETURN_GOODS_DETAIL WHERE LEFT(BkSrNo,1)= '0' AND LEN(BkSrNo)=5