SELECT * FROM #Request.prefix_db_agency#.pAssessments JOIN #Request.prefix_db_agency#.pAdmit ON pAssessments.Admit_ID = pAdmit.Admit_ID 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 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%' 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 = 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 UPDATE #Request.prefix_db_agency#.pAssessments SET F264 = , Record_Mod_Date = , Record_Mod_By = WHERE AutoAssmt_ID = AND status = 0 UPDATE #Request.prefix_db_agency#.pAssessments SET F197 = NULL WHERE AutoAssmt_ID = UPDATE #Request.prefix_db_agency#.pAssessments SET F197 = NULL WHERE AutoAssmt_ID IN (#Form.AutoAssmt_ID#)