UPDATE #Request.prefix_db_agency#.Assessment_New SET Cog_Function_M0560 = '#form.Cog_Function_M0560#', Cog_Function_M0560 = '', Urinary_INcont_M0520 = '#form.Urinary_INcont_M0520#', Urinary_INcont_M0520 = '', Hospice_Assess = '#form.Karnof#', Hospice_Assess = '', M0250_Assess = '#form.Nutrition#', M0250_Assess = '', Therapies_Home_M0250 = '#form.NutriTherap#', Therapies_Home_M0250 = '', Endocrine_Assess = '#form.Endocrine#', Endocrine_Assess = '', M0440_Assess = '#form.Skin#', M0440_Assess = '', M0490_Assess = '#form.Cardio#', M0490_Assess = '', M0520_Assess = '#form.Geni#', M0520_Assess = '', M0540_Assess = '#form.Gastro#', M0540_Assess = '', M0550_Assess = '#form.Ostomy#', M0550_Assess = '', M0610_Assess = '#form.Neuro#', M0610_Assess = '', M0650_Assess = '#form.Musculo#', M0650_Assess = '', Home_Safety_Assess = '#form.Home#', Home_Safety_Assess = '', Ostomy_for_Bowel_M0550 = '#form.HomeHealth#', Ostomy_for_Bowel_M0550 = '', Assessment_note = '#form.txtComment#' Assessment_note = '' WHERE Assessment_ID= #form.txtAssId# update #Request.prefix_db_agency#.Assessment_New set HHRG_175_Score="",HHRG_230_Score="",HHRG_250_Score="",HHRG_390_Score="",HHRG_420_Score="",HHRG_440_Score="" where assessment_id=#session.cs.AssessmentId# UPDATE #Request.prefix_db_agency#.Diagnosis SET Dx_Order = '#Order#' WHERE Diagnosis.Assessment_ID=#session.cs.AssessmentId# and Diagnosis_ID=#UpdateID# select ICD from #Request.prefix_db_agency#.Diagnosis where assessment_id=#session.cs.AssessmentId# and Dx_Order = '#Order#' update #Request.prefix_db_agency#.Assessment_New set HHRG_175_Score ='#geticd.ICD#' where assessment_id=#session.cs.AssessmentId# update #Request.prefix_db_agency#.Assessment_New set HHRG_230_Score ='#geticd.ICD#' where assessment_id=#session.cs.AssessmentId# update #Request.prefix_db_agency#.Assessment_New set HHRG_250_Score ='#geticd.ICD#' where assessment_id=#session.cs.AssessmentId# update #Request.prefix_db_agency#.Assessment_New set HHRG_390_Score ='#geticd.ICD#' where assessment_id=#session.cs.AssessmentId# update #Request.prefix_db_agency#.Assessment_New set HHRG_420_Score ='#geticd.ICD#' where assessment_id=#session.cs.AssessmentId# update #Request.prefix_db_agency#.Assessment_New set HHRG_440_Score ='#geticd.ICD#' where assessment_id=#session.cs.AssessmentId#