SELECT * FROM #Request.prefix_db_agency#.pAssessments WHERE Assmt_ID = AND status = SELECT ques.answer_label, answ.answer, answ.srt_id FROM #Request.prefix_db_lookup#.#Request.assessment_questions_lookup# ques INNER JOIN #Request.prefix_db_lookup#.#Request.assessment_answers_lookup# answ ON answ.question_id = ques.ques_id AND answ.assessment_reason = ques.assessment_reason WHERE ques.Deleted = 0 AND answ.Deleted = 0 AND ques.answer_label IN () AND ques.assessment_reason IN () ORDER BY answ.srt_id ASC UPDATE #Request.prefix_db_agency#.pAssessments SET #_c0500Fld# = , Record_Mod_Date = , Record_Mod_By = WHERE Assmt_ID = AND status = 0 UPDATE #Request.prefix_db_agency#.pAssessments SET , #_d0150Parent# = , Record_Mod_Date = , Record_Mod_By = WHERE Assmt_ID = AND status = 0 UPDATE #Request.prefix_db_agency#.pAssessments SET #_m1700Fld# = , #_m1710Fld# = , Record_Mod_Date = , Record_Mod_By = WHERE Assmt_ID = AND status = 0