SELECT TABLE_SCHEMA FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_SCHEMA like '%agency_1150%' group by TABLE_SCHEMA SELECT pSchedules.* , pSchedules.Schedule_ID, pSchedules.Total_Units, pSchedules.Visit_Date, pSchedules.Rev_ID, pAssessments.F300 AS HIPPS_Code,pAssessments.Assmt_ID,pAssessments.F26 AS Assessment_Reason_M0100, pAssessments.F177 Certification_Start,pAssessments.F178 Certification_End,pAssessments.Patient_ID , pRevenue_Code.Measure, pRevenue_Code.EClaim_Price,pRevenue_Code.Contract_Rate, pRevenue_Code.Contract_Rate_Effective_Date, pRevenue_Code.Contract_Rate_End_Date, pRevenue_Code.Payer_ID, pRevenue_Code.Visit_Type FROM #Request.prefix_db_agency#.pSchedules, #Request.prefix_db_agency#.pAssessments, #Request.prefix_db_agency#.pRevenue_Code WHERE pAssessments.Assmt_ID = pSchedules.Assmt_ID AND pRevenue_Code.Rev_CodeID = pSchedules.Rev_ID AND pSchedules.Status = 0 AND pSchedules.Invoice_ID > 0 AND pRevenue_Code.Contract_Rate > 0 AND pSchedules.Total_Contract = '0.00' AND pAssessments.Status = 0 UPDATE #Request.prefix_db_agency#.pSchedules SET Total_Contract = #NumberFormat(Request.Total_Contract,'_____.__')# WHERE Schedule_ID = #Schedule_ID#