SELECT Remit_No FROM #Request.prefix_db_agency#.pDeposit WHERE Dep_ID = AND Status = 0 SELECT Dep_ID FROM #Request.prefix_db_agency#.pDeposit WHERE Remit_No = AND Status = 0 UPDATE #Request.prefix_db_agency#.pDeposit SET Date_Create = , Date_Check = , Date_Deposit = , Remit_No = , Check_Total = , Total_Provider = , Payer_ID = , Pay_Name = , Record_Modified_Date = , Record_Modified_By = WHERE Remit_No = AND Status = 0 SELECT Dep_ID FROM #Request.prefix_db_agency#.pDeposit WHERE Remit_No = AND Status = 0 SELECT Dep_ID FROM #Request.prefix_db_lookup#.pDeposit_temp WHERE Remit_No = AND Agency_ID = AND Status = 0 INSERT INTO #Request.prefix_db_lookup#.pDeposit_temp (Agency_ID, Payer_ID, Date_Create, Date_Deposit, Date_Check, Deposit_Type, Check_Total,Total_Provider, Remit_No, Internal_Control_number,Pay_Name, Net_Total, Record_Created_Date, Record_Created_By, Record_Modified_Date, Record_Modified_By) VALUES( , , , , , NULL, , , , NULL, , '0.00', , , , ) SELECT LAST_INSERT_ID() as LastInsertID