UPDATE #Request.prefix_db_agency#.pDeposit SET Date_Create = #CreateODBCDate(form.Date_Create)#, Date_Check = #CreateODBCDate(form.Date_Check)#, Date_Deposit = #CreateODBCDate(form.Date_Deposit)#, Remit_No = '#form.Remit_No#', Check_Total = '#form.Check_Total#', Total_Provider = '#form.Total_Provider#', Payer_ID = '#form.Payer_ID#', Record_Modified_Date = #now()#, Record_Modified_By = '#session.employeeid#' WHERE Dep_ID = '#form.Dep_ID#' 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