SELECT * FROM #Request.prefix_db_agency#.pRevenue_Code WHERE Rev_CodeID = INSERT INTO #Request.prefix_db_agency#.pRevenue_Code ( Agency_ID, Payer_ID, Status, Rev_Code, HCPCS, Tier, Measure, Visit_Type, Description, QB_Export, TimeAuthorization, Modifier, GL_Account, Units, EClaim_Price, Balance, Quick_Books_Price, New_EClaim_Price, New_EClaim_Price_Eff_Enddate, New_QuickBooks_Price, New_QuickBooks_Effdate, Set_Units, Contract_Rate, Contract_Rate_Effective_Date, Contract_Rate_End_Date ) VALUES ( , , , , , , , , , , , , , , , , , , , , , , , , )