FOR XML EXPLICIT
-
Hey there people, I genereate xml from the datatables, but i need to group and structure the xml more correctly. could you please assist me in this matter. Here is the code what i am doing, select 1 AS Tag, NULL AS Parent, NULL AS 'FORMSETXML!1!FORMSETXML', NULL AS 'FORMSET!2!FORMSET', NULL AS 'FORMSET!2!FRM_SET_CDE', NULL AS 'FORMSET!2!SYS_LNG_CDE', NULL AS 'FORMSET!2!FRM_SET_TYP', NULL AS 'FORMSET!2!FRM_SET_CPT', NULL AS 'FORMSET!2!EXT_STP_NME', NULL AS 'FORMSET!2!TIMESTAMP', NULL AS 'FORMSETDEFINITION!3!FORMSETDEFINITION', NULL AS 'FORMSETDEFINITION!3!ENTITY', NULL AS 'FORMSETDEFINITION!3!CTL_IDN', NULL AS 'FORMSETATTRIBUTE!4!FORMSETATTRIBUTE', NULL AS 'FORMSETATTRIBUTE!4!ATR_FRY_NME' UNION ALL SELECT 2 AS Tag, 1 AS Parent, null, frm_set.frm_set_cde, frm_set.frm_set_cde, frm_set.sys_lng_cde, frm_set.frm_set_typ_cde, frm_set.frm_set_cpt, 'TEST STORED PROC', GETDATE(), null, frm_set_def.ent_cde, frm_set_def.ctl_idn, null, frm_set_atr.atr_fry_nme FROM mda_form_set frm_set INNER JOIN mda_form_set_definition frm_set_def ON (frm_set.frm_set_cde = frm_set_def.frm_set_cde and frm_set.sys_lng_cde = frm_set_def.sys_lng_cde) INNER JOIN mda_attribute frm_set_atr ON (frm_set_def.ent_cde = frm_set_atr.ent_cde and frm_set_def.atr_cde = frm_set_atr.atr_cde) UNION ALL SELECT 3 AS Tag, 2 AS Parent, null, frm_set.frm_set_cde, frm_set.frm_set_cde, frm_set.sys_lng_cde, frm_set.frm_set_typ_cde, frm_set.frm_set_cpt, 'TEST STORED PROC', GETDATE(), null, frm_set_def.ent_cde, frm_set_def.ctl_idn, null, frm_set_atr.atr_fry_nme FROM mda_form_set_definition frm_set_def INNER JOIN mda_form_set frm_set ON (frm_set.frm_set_cde = frm_set_def.frm_set_cde and frm_set.sys_lng_cde = frm_set_def.sys_lng_cde) INNER JOIN mda_attribute frm_set_atr ON (frm_set_def.ent_cde = frm_set_atr.ent_cde and frm_set_def.atr_cde = frm_set_atr.atr_cde) UNION ALL SELECT 4 AS Tag, 3 AS Parent, null, frm_set.frm_set_cde, frm_set.frm_set_cde, frm_set.sys_lng_cde, frm_set.frm_set_typ_cde, frm_set.frm_set_cpt, 'TEST STORED PROC', GETDATE(), null, frm_set_def.ent_cde, frm_set_def.ctl_idn, null, frm_set_atr.atr_fry_nme FROM mda_attribute frm_set_atr INNER JOIN mda_form_set_definition frm_set_def ON (frm_set_def.ent_cde = frm_set_atr.ent_cde and frm_set_def.atr_cde = f