Create Table Tmp_RECEIVED_DETAIL (RecSrNo Varchar(15),RecCustCode Varchar(7),RecCashCheque Varchar(700),RecAmt Money,RecDate DateTime,RecChequeNo Varchar(700),RecBankName Varchar(700),RecSuppCode Varchar(7) Foreign Key References SUPPLIER_MASTER(SuppCode),RecRemark Varchar(255),RecGRReceived Varchar(3),RecFirmCode Varchar(7),RecFirmSrNo Varchar(15),CompCode Varchar(7) Foreign Key References COMPANY_DETAIL(CompCode),RecCurDate DateTime,RecCurTime DateTime,RecUName Varchar(255),RecBrokerPerc Money,RecBrokerAmt Money,PackChrg Money,CompSrNo Varchar(15),RecExcess Money,EntNo Varchar(20),BrokLessPerc Money,BrokLessAmt Money,NeftRtgs Varchar(1),GSTPerc Money)
Create Table Tmp_RECEIVED_ADDLESS_DETAIL(RecSrNo Varchar(15),RecBillNo Varchar(15),GRLess Money,RateDiff Money,ClaimLess Money,DiscPerc Money,DiscAmt Money,BankComm Money,PackTrans Money,OtherLess Money,AddIntPerc Money,AddIntAmt Money,OtherAdd Money,PaidAmt Money,Status Varchar(7),CompCode Varchar(7) Foreign key References COMPANY_DETAIL (CompCode))
CREATE TABLE Tmp_RECEIVED_PAYMENT_DETAIL (RecSrNo Varchar(15),RecISrNo Numeric(6),RecCashCheque Varchar(700),RecChequeNo Varchar(700),RecDate DateTime,RecBankName Varchar(700),RecAmt Money,CompCode Varchar(7) Foreign key References COMPANY_DETAIL (CompCode))
CREATE TABLE Tmp_RECEIVED_IMAGES_DETAIL (RecSrNo Varchar(15),RecFirmCode Varchar(7),ImgPath Varchar(700))
    
INSERT INTO Tmp_RECEIVED_DETAIL SELECT * FROM RECEIVED_DETAIL WHERE RecSRNo>='024557' and len(recsrno)=6
INSERT INTO Tmp_RECEIVED_ADDLESS_DETAIL SELECT * FROM RECEIVED_ADDLESS_DETAIL WHERE RecSRNo>='024557' and len(recsrno)=6
INSERT INTO Tmp_RECEIVED_PAYMENT_DETAIL SELECT * FROM RECEIVED_PAYMENT_DETAIL WHERE RecSRNo>='024557' and len(recsrno)=6
INSERT INTO Tmp_RECEIVED_IMAGES_DETAIL SELECT* FROM RECEIVED_IMAGES_DETAIL WHERE RecSRNo>='024557' and len(recsrno)=6
   
    
UPDATE Tmp_RECEIVED_DETAIL SET RecSrNo= RIGHT('000000'+CONVERT(Varchar(255),CONVERT(NUMERIC(6),RecSrNo)-24263),6)
UPDATE Tmp_RECEIVED_PAYMENT_DETAIL SET RecSrNo= RIGHT('000000'+CONVERT(Varchar(255),CONVERT(NUMERIC(6),RecSrNo)-24263),6)
UPDATE Tmp_RECEIVED_IMAGES_DETAIL SET RecSrNo= RIGHT('000000'+CONVERT(Varchar(255),CONVERT(NUMERIC(6),RecSrNo)-24263),6)
UPDATE Tmp_RECEIVED_ADDLESS_DETAIL SET RecSrNo= RIGHT('000000'+CONVERT(Varchar(255),CONVERT(NUMERIC(6),RecSrNo)-24263),6)


DELETE FROM RECEIVED_ADDLESS_DETAIL WHERE RecSRNo>='024557' and len(recsrno)=6
DELETE FROM RECEIVED_PAYMENT_DETAIL WHERE RecSRNo>='024557' and len(recsrno)=6
DELETE FROM RECEIVED_IMAGES_DETAIL WHERE RecSRNo>='024557' and len(recsrno)=6
DELETE FROM RECEIVED_DETAIL WHERE RecSRNo>='024557' and len(recsrno)=6    

INSERT INTO RECEIVED_DETAIL SELECT * FROM Tmp_RECEIVED_DETAIL 
INSERT INTO RECEIVED_ADDLESS_DETAIL SELECT * FROM Tmp_RECEIVED_ADDLESS_DETAIL 
INSERT INTO RECEIVED_PAYMENT_DETAIL SELECT * FROM Tmp_RECEIVED_PAYMENT_DETAIL 
INSERT INTO RECEIVED_IMAGES_DETAIL SELECT* FROM Tmp_RECEIVED_IMAGES_DETAIL 


drop table Tmp_RECEIVED_ADDLESS_DETAIL
drop table Tmp_RECEIVED_PAYMENT_DETAIL
drop table Tmp_RECEIVED_IMAGES_DETAIL 
drop table Tmp_RECEIVED_DETAIL