SELECT * FROM #Request.prefix_db_agency#.pDeposit WHERE Dep_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, , '0.00', , , , ) SELECT LAST_INSERT_ID() AS LastInsertID