UPDATE #Request.prefix_db_agency#.Assessment_New SET Assessment_note='#Comments#', Date_Most_Recent_M0903='#DateFormat(Date_Most_Recent_M0903,"yyyy-mm-dd")#', Date_Most_Recent_M0903 =null, Date_Discharge_M0906='#DateFormat(Date_Discharge_M0906,"yyyy-mm-dd")#', Date_Discharge_M0906 = null, Assessment_Completed_M0090='#DateFormat(Assessment_Completed_M0090,"yyyy-mm-dd")#', Assessment_Completed_M0090 =null, M2004_Med_Int='#M2004_Med_Int#', M2004_Med_Int =null, AssessmentType_New ='1', Admission_Status='Complete' AssessmentType_New ='0', Admission_Status='In Progress' Where Assessment_New.Assessment_ID='#session.cs.AssessmentId#'