USE T202324

SELECT * FROM RECEIVED_DETAIL WHERE LEN(RECSRNO)=6 ORDER BY RECSRNO

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,CommOn Varchar(20))
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>='034902' and len(recsrno)=6
INSERT INTO Tmp_RECEIVED_ADDLESS_DETAIL SELECT * FROM RECEIVED_ADDLESS_DETAIL WHERE RecSRNo>='034902' and len(recsrno)=6
INSERT INTO Tmp_RECEIVED_PAYMENT_DETAIL SELECT * FROM RECEIVED_PAYMENT_DETAIL WHERE RecSRNo>='034902' and len(recsrno)=6
INSERT INTO Tmp_RECEIVED_IMAGES_DETAIL SELECT* FROM RECEIVED_IMAGES_DETAIL WHERE RecSRNo>='034902' and len(recsrno)=6
   
    
Note : 34902-Form Where Srno party Want To Start 

UPDATE Tmp_RECEIVED_DETAIL SET RecSrNo= RIGHT('000000'+CONVERT(Varchar(255),CONVERT(NUMERIC(6),RecSrNo)-30000),6)
UPDATE Tmp_RECEIVED_PAYMENT_DETAIL SET RecSrNo= RIGHT('000000'+CONVERT(Varchar(255),CONVERT(NUMERIC(6),RecSrNo)-30000),6)
UPDATE Tmp_RECEIVED_IMAGES_DETAIL SET RecSrNo= RIGHT('000000'+CONVERT(Varchar(255),CONVERT(NUMERIC(6),RecSrNo)-30000),6)
UPDATE Tmp_RECEIVED_ADDLESS_DETAIL SET RecSrNo= RIGHT('000000'+CONVERT(Varchar(255),CONVERT(NUMERIC(6),RecSrNo)-30000),6)


DELETE FROM RECEIVED_ADDLESS_DETAIL WHERE RecSRNo>='034902' and len(recsrno)=6
DELETE FROM RECEIVED_PAYMENT_DETAIL WHERE RecSRNo>='034902' and len(recsrno)=6
DELETE FROM RECEIVED_IMAGES_DETAIL WHERE RecSRNo>='034902' and len(recsrno)=6
DELETE FROM RECEIVED_DETAIL WHERE RecSRNo>='034902' 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