SELECT Patient_ID,Agency_Id,Assessment_Tracker_ID,Assessment_Reason_M0100,Discharged_From_M0175,Assessment_Completed_M0090 , Braden_1_Sensory, Braden_2_Moisture, Braden_3_Activity, Braden_4_Mobility, Braden_5_Nutrition, Braden_6_Friction,M1310_1, M1308_d_3_Pressure,M1308_d_2_Pressure,Pressure_Ulcer_b_M0450,Pressure_Ulcer_c_M0450,Pressure_Ulcer_d_M0450,Pressure_Ulcer_e_M0450, M1300_Pressure,Stasis_Ulcer_M0468,Surgical_Wound_M0482,M1310_1 FROM #Request.prefix_db_agency#.Assessment_New WHERE Assessment_ID='#Assessment_ID#' SELECT Wnd_Len_1,Wnd_Len_2,Wnd_Wid_1,Wnd_Wid_2,Wnd_Dep_1,Wnd_Dep_2 FROM #Request.prefix_db_agency#.PatientVisitDetails where assessment_id ='#Assessment_ID#' and type='Wound' and wnd_type is not null limit 1 SELECT Wnd_Stage,Wnd_Status FROM #Request.prefix_db_agency#.PatientVisitDetails where assessment_id ='#Assessment_ID#' and type='Wound' and wnd_type is not null update #Request.prefix_db_agency#.Assessment_New Set M1302_Pressure = '#M1302_Pressure#' WHERE Assessment_ID='#Assessment_ID#' update #Request.prefix_db_agency#.Assessment_New Set M1306_Unhealed_Pressure = '#M1306_Unhealed_Pressure#' WHERE Assessment_ID='#Assessment_ID#' update #Request.prefix_db_agency#.Assessment_New Set Pressure_Ulcer_Status_M0464='#Pressure_Ulcer_Status_M0464#' WHERE Assessment_ID='#Assessment_ID#' update #Request.prefix_db_agency#.Assessment_New Set M1310_Length = '#M1310_Length#',M1310_1 = '#M1310_1#',M1312_Width = '#M1312_Width#', M1312_1 = '#M1312_1#',M1314_Depth = '#M1314_Depth#',M1314_1 = '#M1314_1#' WHERE Assessment_ID='#Assessment_ID#' update #Request.prefix_db_agency#.Assessment_New Set Pressure_Ulcer_Status_M0464 = '#Pressure_Ulcer_Status_M0464#' WHERE Assessment_ID='#Assessment_ID#' update #Request.prefix_db_agency#.Assessment_New Set Pressure_Ulcer_b_M0450 = '#Pressure_Ulcer_b_M0450#',Pressure_Ulcer_c_M0450 = '#Pressure_Ulcer_c_M0450#' ,Pressure_Ulcer_d_M0450 = '#Pressure_Ulcer_d_M0450#',Pressure_Ulcer_e_M0450 = '#Pressure_Ulcer_e_M0450#' ,M1308_d_2_Pressure = '#M1308_d_2_Pressure#',M1308_d_3_Pressure = '#M1308_d_3_Pressure#' WHERE Assessment_ID='#Assessment_ID#' update #Request.prefix_db_agency#.Assessment_New Set M1308_a_12_Pressure = '#M1308_a_12_Pressure#',M1308_b_12_Pressure = '#M1308_b_12_Pressure#' ,M1308_c_12_Pressure = '#M1308_c_12_Pressure#',M1308_d_12_Pressure = '#M1308_d_12_Pressure#' ,M1308_d_22_Pressure = '#M1308_d_22_Pressure#',M1308_d_32_Pressure = '#M1308_d_32_Pressure#' WHERE Assessment_ID='#Assessment_ID#' update #Request.prefix_db_agency#.Assessment_New Set Pressure_Ulcer_a_M0450 = '#Pressure_Ulcer_a_M0450#',Pressure_Ulcer_Stage_M0460 = '#Pressure_Ulcer_Stage_M0460#' WHERE Assessment_ID='#Assessment_ID#' update #Request.prefix_db_agency#.Assessment_New Set M1302_Pressure = '#M1302_Pressure#' WHERE Assessment_ID='#Assessment_ID#' update #Request.prefix_db_agency#.Assessment_New Set Pressure_Ulcer_b_M0450 = '#Pressure_Ulcer_b_M0450#', Pressure_Ulcer_c_M0450 = '#Pressure_Ulcer_c_M0450#', Pressure_Ulcer_d_M0450 = '#Pressure_Ulcer_d_M0450#', Pressure_Ulcer_b_M0450 = '#Pressure_Ulcer_b_M0450#', Pressure_Ulcer_e_M0450 = '#Pressure_Ulcer_e_M0450#', M1308_a_12_Pressure = '#M1308_a_12_Pressure#', M1308_b_12_Pressure = '#M1308_b_12_Pressure#', M1308_c_12_Pressure = '#M1308_c_12_Pressure#', M1308_d_12_Pressure = '#M1308_d_12_Pressure#', M1308_d_22_Pressure = '#M1308_d_22_Pressure#', M1308_d_32_Pressure = '#M1308_d_32_Pressure#', M1308_d_2_Pressure = '#M1308_d_2_Pressure#', M1308_d_3_Pressure = '#M1308_d_3_Pressure#', Pressure_Ulcer_Status_M0464 = '#Pressure_Ulcer_Status_M0464#', M1310_Length = '#M1310_Length#', M1310_1 = '#M1310_1#', M1312_Width = '#M1312_Width#', M1312_1 = '#M1312_1#', M1314_Depth = '#M1314_Depth#', M1314_1 = '#M1314_1#' WHERE Assessment_ID='#Assessment_ID#' update #Request.prefix_db_agency#.Assessment_New Set Pressure_Ulcer_Stage_M0460 = '#Pressure_Ulcer_Stage_M0460#' WHERE Assessment_ID='#Assessment_ID#' update #Request.prefix_db_agency#.Assessment_New Set Surgical_Wound_Status_M0488 = '#Surgical_Wound_Status_M0488#' WHERE Assessment_ID='#Assessment_ID#'