SELECT IFNULL(SUM(Total_Visits),0) AS tot_visits FROM #Request.prefix_db_agency#.pAuths WHERE Assmt_ID = AND Skill = '#skilltype#' AND Status = 0 SELECT * FROM #Request.prefix_db_agency#.pSchedules WHERE Assmt_ID = AND Status = SELECT * FROM #Request.prefix_db_agency#.pAuths WHERE Assmt_ID = AND Skill = '#skilltype#' AND Status = 0 SELECT * FROM getallschedule WHERE Auth_ID IN (#auth_ids#) AND (Missed = 1 OR pgnotesdraft = 2) SELECT * FROM #Request.prefix_db_agency#.pWoundsVitals WHERE Assmt_ID = AND status = 0 AND VitalOrWound = 'vital' AND Status = 0 SELECT SUM(CASE WHEN LEFT(Answer,2) > 2 THEN LEFT(Answer,2) ELSE '2' END ) as sev , Answer,Severity, pProblem.* FROM #Request.prefix_db_agency#.pProblem WHERE Assmt_ID = AND status = 0 AND skill = '#skilltype#' AND M0_No NOT LIKE 'M102%' AND Description like 'GG%' SELECT * FROM #Request.prefix_db_agency#.pCareplan WHERE Assmt_ID = AND status = 0 AND Type like '%goal%' AND Status = 0 SELECT * FROM getallcareplans WHERE Skill = '#skilltype#' AND (Date_Resolve IS NULL OR Date_Resolve = '#DateFormat(GetSched.Visit_Date,"yyyy-mm-dd")#') SELECT IFNULL(pPathway.Severity,0) AS Sev, pCareplan.* FROM #Request.prefix_db_agency#.pCareplan JOIN #Request.prefix_db_lookup#.pPathway ON pPathway.Item_ID = pCareplan.Item_ID AND pPathway.Type = pCareplan.Type WHERE Assmt_ID = AND pCareplan.status = 0 AND pCareplan.Type IN ('goal','patient_goal','discharge_plan') AND pCareplan.Skill = '#skilltype#' AND (pCareplan.Date_Resolve IS NULL OR pCareplan.Date_Resolve = '#DateFormat(GetSched.Visit_Date,"yyyy-mm-dd")#') AND pCareplan.Status = 0 GROUP BY pCareplan.Item_ID SELECT * FROM getallcareplans WHERE Skill = '#skilltype#' AND Type = 'goal' AND (Date_Resolve IS NULL OR Date_Resolve >= '#DateFormat(GetSched.Visit_Date,"yyyy-mm-dd")#') SELECT SUM(CASE WHEN Description like '%- 01%' THEN 1 WHEN Description like '%- 02%' THEN 2 WHEN Description like '%- 03%' THEN 3 WHEN Description like '%- 04%' THEN 4 WHEN Description like '%- 05%' THEN 5 WHEN Description like '%- 06%' THEN 6 ELSE '4' END ) as goals, pCareplan.* FROM #Request.prefix_db_agency#.pCareplan WHERE Assmt_ID = AND status = 0 AND skill = '#skilltype#' AND Type IN ('goal' ) AND Status = 0 AND (Date_Resolve IS NULL OR goal_met = 1) UPDATE IGNORE #Request.prefix_db_agency#.pSchedules SET total_visits = '#request.total_visits#', severity_problem = '#request.severity_problem#', severity_goal = '#request.severity_goal#', total_goal = #request.total_goal# WHERE Assmt_ID = AND Schedule_ID = AND Status = SELECT * FROM getallschedule WHERE Schedule_ID = '#Request.Schedule_ID#' SELECT * FROM getallschedule WHERE Auth_ID = '#getallschedule.Auth_ID#' AND pgnotesdraft != 2 SELECT IFNULL(SUM(YesOrNo),0) as sev FROM #Request.prefix_db_agency#.pProgress WHERE Assmt_ID = AND status = 0 AND Schedule_ID = AND Type like '%goal%' AND Type = 'goal' SELECT IFNULL(SUM(YesOrNo),0) as sev FROM #Request.prefix_db_agency#.pProgress WHERE Assmt_ID = AND status = 0 AND Schedule_ID = AND Type = 'goal' SELECT IFNULL(SUM(severity),0) as sev FROM #Request.prefix_db_agency#.pProgress WHERE Assmt_ID = AND status = 0 AND Schedule_ID = AND Type IN ('problem','symptom') SELECT IFNULL(SUM(Severity),0) as sev FROM #Request.prefix_db_agency#.pProgress WHERE Assmt_ID = AND status = 0 AND Schedule_ID = AND Type like '%problem%' AND Description like 'GG%%' UPDATE #Request.prefix_db_agency#.pSchedules SET increment_problem = '#request.increment_problem#', increment_this_visit = #request.increment_this_visit#, result_this_visit = #request.result_this_visit#, increment_goal = #request.increment_goal#, increment_goal_this_visit = #request.increment_goal_this_visit#, goal_result_this_visit = #request.goal_result_this_visit#, total_increment = #request.total_increment#, total_result = #request.total_result# WHERE Assmt_ID = AND Schedule_ID = AND Status =