UPDATE #Request.prefix_db_agency#.pAssessments SET #arguments.columnname# = WHERE Assmt_ID = AND status = 0 SELECT *, CASE WHEN LEFT(F26,1) = '4' THEN IFNULL(LEFT(F40,1),0) ELSE IFNULL(LEFT(F34,1),0) END AS M1700, CASE WHEN (F26 = '1 - Start of care - further visits planned - Physical Therapy' OR LEFT(F26,1) = '4') THEN IFNULL(LEFT(F72,1),0) ELSE IFNULL(LEFT(F73,1),0) END AS M2102d FROM #Request.prefix_db_agency#.pAssessments WHERE Status = 0 AND Assmt_ID = AND (F26 like '1%' OR F26 like '4%') ORDER BY F26 DESC,F176 DESC; SELECT * FROM #Request.prefix_db_lookup#.VBP_Analysis3 WHERE LEFT(SOC_M1700,1) = AND LEFT(SOC_M2102D,1) =