SELECT * FROM #Request.prefix_db_agency#.pAssessments LEFT OUTER JOIN #Request.prefix_db_agency#.pAdmit ON pAssessments.Admit_ID = pAdmit.Admit_ID LEFT OUTER JOIN #Request.prefix_db_agency#.pPatients ON pAssessments.Patient_ID = pPatients.Patient_ID WHERE pAssessments.AutoAssmt_ID = AND pAssessments.status = AND pAdmit.status = 0 AND pPatients.status IN (0,1,4) GROUP BY pAssessments.Assmt_ID ORDER BY pAssessments.F176 DESC UPDATE #Request.prefix_db_agency#.pAssessments SET F197 = WHERE Assmt_ID = SELECT pProblem.*, vetted_190924.ICD AS ICD FROM #Request.prefix_db_agency#.pProblem LEFT OUTER JOIN #Request.prefix_db_lookup#.vetted_190924 ON vetted_190924.Diagnosis = pProblem.Description WHERE pProblem.Assmt_ID = AND pProblem.status = AND M0_No like 'M102%' AND Dx_Order IN (1,2,3,4,5,6) ORDER BY RIGHT(M0_No, 1) ASC LIMIT 0,6 SELECT pPtPayer.Sub_HIC,pPayer.M0150, pPayer.Output as POUT FROM #Request.prefix_db_agency#.pPtPayer JOIN #Request.prefix_db_agency#.pPayer ON pPayer.Pay_ID = pPtPayer.Payer_ID WHERE pPtPayer.Patient_ID = AND pPtPayer.status = AND Left(pPayer.M0150,1) IN ('1','2','3','4') SELECT * FROM #Request.prefix_db_lookup#.pPhysicians WHERE Phys_ID = AND status = SELECT M0150, Sub_HIC FROM GetPayers WHERE M0150 like '1. Medicare (traditional%' SELECT POUT, Sub_HIC FROM GetPayers WHERE M0150 like '%Medicaid%' SELECT * FROM getproblem