SELECT pAssessments.*,pAdmit.M1100_PTNT_LVG_STUTN FROM #Request.prefix_db_agency#.pAssessments JOIN #Request.prefix_db_agency#.pAdmit ON pAssessments.Admit_ID = pAdmit.Admit_ID AND pAdmit.status = 0 WHERE pAssessments.Assmt_ID = AND pAssessments.status = SELECT * FROM #Request.prefix_db_lookup#.VBP_Analysis WHERE M1100 like SELECT * FROM getallassesments WHERE F27 = '#item#' SELECT * FROM getallVBP WHERE M1700 = '#M1700#' AND M2102d = '#M2102d#' UPDATE #Request.prefix_db_agency#.pAssessments SET F322 = '#getsVBP.MorV#' WHERE Assmt_ID = AND status =