UPDATE #Request.prefix_db_agency#.Assessment_New SET #datalist[i]# = NULL "#datalist[i+1]#" ,AssessmentType_New = 1 ,Admission_Status='Complete' WHERE Assessment_ID = '#session.cs.AssessmentId#' SELECT * FROM Assessment_Answer_lookup WHERE DELETED <> 1 AND assessment_reason = '#assessment_reason#' GROUP BY answer_label SELECT * FROM Assessment_Questions_lookup WHERE DELETED <> 1 AND assessment_reason = '#assessment_reason#' SELECT * FROM #Request.prefix_db_agency#.Assessment_New WHERE Assessment_ID = '#session.cs.AssessmentId#' AND #get_all_answers.answer_label# IS NOT NULL UPDATE #Request.prefix_db_agency#.Assessment_New SET M1040_Influ = '#hdnM1040_Influ#', M1045_Influ = '#hdnM1045_Influ#', M1050_Pneu = '#hdnM1050_Pneu#', Assessment_note='#Comments#', M1055_Pneu = '#hdnM1055_Pneu#' Where Assessment_New.Assessment_ID= '#session.cs.AssessmentId#' UPDATE #Request.prefix_db_agency#.Assessment_New SET Breathing_M0490='#Breathing_M0490#', Resp_Treatments_M0500='#Resp#', M1500_Symptoms='#M1500_Symptoms#', Assessment_note='#Comments#', M1510_Hrt_FU='#M1510#' Where Assessment_New.Assessment_ID= '#session.cs.AssessmentId#' UPDATE #Request.prefix_db_agency#.Assessment_New SET M2004_Med_Int='#M2004_Med_Int#', M2015_Drug_Edu='#M2015_Drug_Edu#', Oral_Meds_M0780='#Oral_Meds_M0780#', Assessment_note='#Comments#', Inject_Meds_M0800='#Inject_Meds_M0800#' Where Assessment_New.Assessment_ID='#session.cs.AssessmentId#' UPDATE #Request.prefix_db_agency#.Assessment_New SET Emergent_Care_M0830='#Emergent_Care_M0830#', Assessment_note='#Comments#', Emergent_Care_Reason_M0840='#Reason#' Where Assessment_New.Assessment_ID='#session.cs.AssessmentId#' UPDATE #Request.prefix_db_agency#.Assessment_New SET M2400a_Diabetic='#M2400a_Diabetic#', M2400b_FallsPrev='#M2400b_FallsPrev#', M2400c_Depress='#M2400c_Depress#', M2400d_Pain='#M2400d_Pain#', M2400e_PressUlc='#M2400e_PressUlc#', M2400f_PressUlcMoist='#M2400f_PressUlcMoist#', Inpatient_Facility_M0855='#Inpatient_Facility_M0855#', Assessment_note='#Comments#', Discharge_Disposition_M0870='#Discharge_Disposition_M0870#' Where Assessment_New.Assessment_ID='#session.cs.AssessmentId#' UPDATE #Request.prefix_db_agency#.Assessment_New SET Hospital_Reason_List_M0895='#Reason1#', Nursing_Home_M0900='#Reason2#', Date_Most_Recent_M0903='#DateFormat(Date_Most_Recent_M0903,"yyyy-mm-dd")#', Date_Discharge_M0906='#DateFormat(Date_Discharge_M0906,"yyyy-mm-dd")#', Assessment_Completed_M0090='#DateFormat(Assessment_Completed_M0090,"yyyy-mm-dd")#', Previous_Assessment_number='#Previous_Assessment_number#', AssessmentType_New ='1', Assessment_note='#Comments#', Admission_Status='Complete' Where Assessment_New.Assessment_ID='#session.cs.AssessmentId#'