SELECT * FROM #Request.prefix_db_agency#.pProblem WHERE status = 0 AND Assmt_ID IN (#ROC_Assmt_ID#) AND Description NOT LIKE 'GG%' SELECT a2.* FROM #Request.prefix_db_lookup#.#Request.assessment_answers_lookup# a1 JOIN #Request.prefix_db_lookup#.#Request.assessment_answers_lookup# a2 ON a2.common_quest_id = a1.common_quest_id WHERE a1.question_id = AND a2.Item_ID = GROUP BY a2.question_id ORDER BY a2.question_id SELECT * FROM #Request.prefix_db_agency#.pProblem WHERE status < 2 AND Assmt_ID IN (#current_assmt_ID#) AND (Description = '#Description#' OR Answer = '#Description#' OR Problem_ID = '#Problem_ID#' OR (ques_id IN (#related_quest_id#))) AND Path_ID = #Path_ID# AND Item_ID = #Item_ID# GROUP BY Description SELECT IFNULL(MAX(Problem_ID),0)+1 As pProblem_ID FROM #Request.prefix_db_agency#.pProblem INSERT INTO #Request.prefix_db_agency#.pProblem (Problem_ID, Assmt_ID, Status, Careplan, Path_ID, Item_ID, CMSOrder_ID, Skill, ques_id, M0_No, Description, Answer, Severity, dx_order, Oasis_Deficits, manual, Order_ID, WoundVital_ID, Coding_Status, Specific_Orders, Resolved_Date, Assign, Notes, Date_Create, Created_by, Date_Change, Change_by) VALUES ('#pProblem_ID#', #current_assmt_ID#, 0, '#Careplan#', '#Path_ID#', '#Item_ID#', '#CMSOrder_ID#', '#Skill#', '#ques_id#', '#M0_No#', '#Description#', '#Answer#', '#Severity#', '#dx_order#', '#Oasis_Deficits#', '#manual#', '#Order_ID#', '#WoundVital_ID#', '#Coding_Status#', '#Specific_Orders#', '#Resolved_Date#', '#Assign#', '#Notes#', '#Date_Create#', '#Created_by#', '#Date_Change#', '#Change_by#')