declare @GLXML xml = '<MAPPEDVALUES>
<ROW>
<ID>99999999-9999-9999-9999-999999999999</ID>
<PDACCOUNTCODEMAPOFFICEID>1A692E94-3214-44B8-A658-F2927230BC25</PDACCOUNTCODEMAPOFFICEID>
<REVENUETYPEID>E94C5D99-45C3-4832-9394-E52D4639438C</REVENUETYPEID>
<APPLICATIONTYPEID>ECA6E4A7-8B0B-4E80-BAFF-07A3559E4AD4</APPLICATIONTYPEID>
<PAYMENTMETHODID>C24896E3-F243-45A1-BF2C-DA333C2B7F44</PAYMENTMETHODID>
<PDACCOUNTSYSTEMID>4B121C2C-CCE6-440D-894C-EA0DEF80D50B</PDACCOUNTSYSTEMID>
<SEGMENT02TABLEID>1BA6F27F-8454-4FC4-A830-3FDA8CD35D04</SEGMENT02TABLEID>
<SEGMENT03ID>68F1B5E8-9BD5-4D9B-B2F0-12F1A7E347B6</SEGMENT03ID>
<SEGMENT03TABLEID>3298E2CE-EF37-4681-AC12-050979B6C5F3</SEGMENT03TABLEID>
<SEGMENT04ID>6300D932-0E86-4C2C-BE09-6791F5E41E55</SEGMENT04ID>
<SEGMENT04TABLEID>AEBA8FD5-42B6-4D37-93EB-8916BEC1385A</SEGMENT04TABLEID>
<SEGMENT05TABLEID>3EF5D061-5692-40F3-B8AD-1367A8C6FAD5</SEGMENT05TABLEID>
<SEGMENT06ID>A044FAD4-D902-4D56-B197-FBD8877C9AE2</SEGMENT06ID>
<SEGMENT06TABLEID>5B93DEF5-AAA7-482E-B8F7-169EE0DAA53D</SEGMENT06TABLEID>
<ERRORMESSAGE></ERRORMESSAGE>
<ERRORCODE>0</ERRORCODE>
<HASHVALUE>0</HASHVALUE>
<MD5HASHVALUE>087C5BE7-2DFD-A5B4-5822-288EC0A2DDC1</MD5HASHVALUE>
</ROW>
</MAPPEDVALUES>'
; with GLSEGMENTS as (
SELECT
T.c.value('(SEGMENT02TABLEID)[1]', 'uniqueidentifier') AS SEGMENT02TABLEID,
T.c.value('(SEGMENT02ID)[1]', 'uniqueidentifier') AS SEGMENT02ID,
T.c.value('(SEGMENT03TABLEID)[1]', 'uniqueidentifier') AS SEGMENT03TABLEID,
T.c.value('(SEGMENT03ID)[1]', 'uniqueidentifier') AS SEGMENT03ID,
T.c.value('(SEGMENT04TABLEID)[1]', 'uniqueidentifier') AS SEGMENT04TABLEID,
T.c.value('(SEGMENT04ID)[1]', 'uniqueidentifier') AS SEGMENT04ID,
T.c.value('(SEGMENT05TABLEID)[1]', 'uniqueidentifier') AS SEGMENT05TABLEID,
T.c.value('(SEGMENT05ID)[1]', 'uniqueidentifier') AS SEGMENT05ID,
T.c.value('(SEGMENT06TABLEID)[1]', 'uniqueidentifier') AS SEGMENT06TABLEID,
T.c.value('(SEGMENT06ID)[1]', 'uniqueidentifier') AS SEGMENT06ID
FROM @GLXML.nodes('/MAPPEDVALUES/ROW') T(c)
)
select SEGMENT02TABLEID as TABLEID, SEGMENT02ID as VALUEID from GLSEGMENTS
union all
select SEGMENT03TABLEID as TABLEID, SEGMENT03ID as VALUEID from GLSEGMENTS
union all
select SEGMENT04TABLEID as TABLEID, SEGMENT04ID as VALUEID from GLSEGMENTS
union all
select SEGMENT05TABLEID as TABLEID, SEGMENT05ID as VALUEID from GLSEGMENTS
union all
select SEGMENT06TABLEID as TABLEID, SEGMENT06ID as VALUEID from GLSEGMENTS