UFN_PDCOMPOSITESEGMENTENTRIES_FROMITEMLISTXML

create function dbo.UFN_PDCOMPOSITESEGMENTENTRIES_FROMITEMLISTXML(@ITEMLISTXML xml)
returns table
as 
return (
  select
     T.c.value('(ID)[1]','uniqueidentifier') AS 'ID'
    ,T.c.value('(ID1)[1]','uniqueidentifier') AS 'ID1'
    ,T.c.value('(ID2)[1]','uniqueidentifier') AS 'ID2'
    ,T.c.value('(ID3)[1]','uniqueidentifier') AS 'ID3'
    ,T.c.value('(ID4)[1]','uniqueidentifier') AS 'ID4'
    ,T.c.value('(NAME)[1]','nvarchar(50)') AS 'NAME'
    ,T.c.value('(SEGMENTID)[1]','uniqueidentifier') AS 'SEGMENTID'
FROM @ITEMLISTXML.nodes('/MAPPINGS/ITEM') T(c)    
)