SELECT TABLE_SCHEMA FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_SCHEMA like '%#Request.prefix_db_agency#%' 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.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 IS NULL OR pSchedules.Total_Contract = '0') AND pAssessments.Status = 0 SELECT Contract_Rate FROM #Request.prefix_db_agency#.pRevenue_Code WHERE Payer_ID = #GetVisits.Payer_ID# AND Visit_Type = '#GetVisits.Visit_Type#' AND Agency_ID = #url.Agency_ID# AND Status = 0 AND Contract_Rate > 0 AND ( Contract_Rate_Effective_Date IS NULL OR Contract_Rate_Effective_Date <= '#GetVisits.Visit_Date#' ) AND ( Contract_Rate_End_Date IS NULL OR Contract_Rate_End_Date >= '#GetVisits.Visit_Date#' ) ORDER BY Contract_Rate_Effective_Date DESC LIMIT 1 UPDATE #Request.prefix_db_agency#.pSchedules SET Total_Contract = #NumberFormat(Request.Total_Contract,'_____.__')# WHERE Schedule_ID = #Schedule_ID# SELECT Invoices.Invoice_ID,Invoices.InvoiceTotal,Invoices.ContractTotal, SUM(Total_Contract) AS totalcontract FROM #Request.prefix_db_agency#.Invoices JOIN #Request.prefix_db_agency#.pSchedules ON Invoices.Invoice_ID = pSchedules.Invoice_ID AND Invoices.Deleted <> 1 WHERE pSchedules.status = 0 AND (Invoices.ContractTotal IS NULL OR ContractTotal = '0') GROUP BY Invoices.Invoice_ID UPDATE #Request.prefix_db_agency#.Invoices SET ContractTotal = #NumberFormat(totalcontract,'_____.__')# WHERE Invoice_ID = #Invoice_ID# AND (IFNULL(Invoice_Lock,0) <> 1)

Updated the Invoices now.So please check on it your web

SELECT Invoices.Invoice_ID,Invoices.InvoiceTotal,Invoices.ContractTotal, SUM(Total_Contract) AS totalcontract FROM #Request.prefix_db_agency#.Invoices JOIN #Request.prefix_db_agency#.pSchedules ON Invoices.Invoice_ID = pSchedules.Invoice_ID AND Invoices.Deleted <> 1 WHERE pSchedules.status = 0 AND Invoices.ContractTotal = '0.00' GROUP BY Invoices.Invoice_ID UPDATE #Request.prefix_db_agency#.Invoices SET ContractTotal = #NumberFormat(totalcontract,'_____.__')# WHERE Invoice_ID = #Invoice_ID# AND (IFNULL(Invoice_Lock,0) <> 1)