SELECT * FROM #Request.prefix_db_lookup#.OASIS_QA_New WHERE question_id = AND answer = DELETE FROM #Request.prefix_db_agency#.pOASIS_QA WHERE Assmt_ID = AND QA_Type = 'OASIS' SELECT * FROM getoasis_qa WHERE question_idCB = AND answerCB = " & #suboasis_qa.answerCT# & " . Because the question " & #getoasis_qa.answer_label# & " answer is " & #getoasis_qa.answer# & "
"/> INSERT INTO #Request.prefix_db_agency#.pOASIS_QA ( Assmt_ID, Emp_ID, Approved,Resolved, QA_Type, Questions_label, Message ) VALUES ( , , , , , , ) SELECT pProblem.*,assessment_questions_lookup.questions_label FROM #Request.prefix_db_agency#.pProblem LEFT OUTER JOIN #Request.prefix_db_lookup#.#Request.assessment_questions_lookup# assessment_questions_lookup ON assessment_questions_lookup.ques_id = pProblem.ques_id WHERE pProblem.Assmt_ID = AND pProblem.status = AND M0_No like 'OASIS%' GROUP BY Problem_ID ORDER BY AutoProblem_ID ASC DELETE FROM #Request.prefix_db_agency#.pOASIS_QA WHERE Assmt_ID = AND QA_Type = INSERT INTO #Request.prefix_db_agency#.pOASIS_QA ( Assmt_ID, Emp_ID, QA_Type, Questions_label, Message ) VALUES ( , , , , ) SELECT * FROM #Request.prefix_db_agency#.pPtmeds left outer join #Request.prefix_db_lookup#.Meds_New ON pPtmeds.Drug_ID = Meds_New.Trade_ID WHERE pPtmeds.Patient_ID = AND pPtmeds.status < 1 GROUP BY PtMeds_ID ORDER BY pPtmeds.status ASC SELECT * FROM #Request.prefix_db_lookup#.meds_pathway_lookup WHERE Path_ID IN ( SELECT Path_ID FROM #Request.prefix_db_agency#.pProblem WHERE Assmt_ID = AND status = GROUP BY Problem_ID ORDER BY AutoProblem_ID ASC) DELETE FROM #Request.prefix_db_agency#.pOASIS_QA WHERE Assmt_ID = AND QA_Type = INSERT INTO #Request.prefix_db_agency#.pOASIS_QA ( Assmt_ID, Emp_ID, QA_Type, Questions_label, Message ) VALUES ( , , , , )