UPDATE #Request.prefix_db_agency#.Assessment_New SET Rehab_Prognosis_M0270 = '#form.Rehab_Prognosis_M0270#', Rehab_Prognosis_M0270 = '', Overall_prognosis_M0260 = '#form.Overall_prognosis_M0260#', Overall_prognosis_M0260 = '', other_agency_involved = '#form.other_agency_involved#', other_agency_involved = '', M0250_Assess = '#form.txtNutrition#', M0250_Assess = '', Therapies_Home_M0250 = '#form.NutriTherap#', Therapies_Home_M0250 = '', M0420_Assess = '#form.painlevel#', M0420_Assess = '', Emergent_Care_M0830 = '#form.chkthrobbing#', Emergent_Care_M0830 = '', Emergent_Care_Reason_M0840 = '#form.radthreshold#', Emergent_Care_Reason_M0840 = '', Inpatient_Facility_M0855 = '#form.Opinion#', Inpatient_Facility_M0855 = '', Nursing_Home_M0900 = '#form.currentpain#', Nursing_Home_M0900 = '', Discharge_Disposition_M0870 = '#form.doeseach#', Discharge_Disposition_M0870 = '', Endocrine_Assess = '#form.txtEndocrine_Assess#', Endocrine_Assess = '', M0440_Assess = '#form.txtSkin#', M0440_Assess = '', M0490_Assess = '#form.txtCardio_Assess#', M0490_Assess = '', M0520_Assess = '#form.txtGeni#', M0520_Assess = '', M0540_Assess = '#form.txtGastro#', M0540_Assess = '', M0550_Assess = '#form.txtOstomy#', M0550_Assess = '', M0610_Assess = '#form.txtNeuro#', M0610_Assess = '', Meal_Prep_M0720 = '#form.txtMusculo#', Meal_Prep_M0720 = '', Home_Safety_Assess = '#form.txtHome#', Home_Safety_Assess = '', M0810_Assess = '#form.txtHomeHealth#', M0810_Assess = '', 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#