UFN_JOURNALENTRYELEMENTS_FROMITEMLISTXML_FLAT

CREATE function [dbo].[UFN_JOURNALENTRYELEMENTS_FROMITEMLISTXML_FLAT](@ITEMLISTXML xml) returns table as
return
select 
     CAST([1] as uniqueidentifier) as DATAELEMENT1ID
    ,CAST([2] as uniqueidentifier) as DATAELEMENT2ID
    ,CAST([3] as uniqueidentifier) as DATAELEMENT3ID
    ,CAST([4] as uniqueidentifier) as DATAELEMENT4ID
    ,CAST([5] as uniqueidentifier) as DATAELEMENT5ID
    ,CAST([6] as uniqueidentifier) as DATAELEMENT6ID
    ,CAST([7] as uniqueidentifier) as DATAELEMENT7ID
    ,CAST([8] as uniqueidentifier) as DATAELEMENT8ID
    ,CAST([9] as uniqueidentifier) as DATAELEMENT9ID
    ,CAST([10] as uniqueidentifier) as DATAELEMENT10ID
    ,CAST([11] as uniqueidentifier) as DATAELEMENT11ID
    ,CAST([12] as uniqueidentifier) as DATAELEMENT12ID
    ,CAST([13] as uniqueidentifier) as DATAELEMENT13ID
    ,CAST([14] as uniqueidentifier) as DATAELEMENT14ID
    ,CAST([15] as uniqueidentifier) as DATAELEMENT15ID
    ,CAST([16] as uniqueidentifier) as DATAELEMENT16ID
    ,CAST([17] as uniqueidentifier) as DATAELEMENT17ID
    ,CAST([18] as uniqueidentifier) as DATAELEMENT18ID
    ,CAST([19] as uniqueidentifier) as DATAELEMENT19ID
    ,CAST([20] as uniqueidentifier) as DATAELEMENT20ID
    ,CAST([21] as uniqueidentifier) as DATAELEMENT21ID
    ,CAST([22] as uniqueidentifier) as DATAELEMENT22ID
    ,CAST([23] as uniqueidentifier) as DATAELEMENT23ID
    ,CAST([24] as uniqueidentifier) as DATAELEMENT24ID
    ,CAST([25] as uniqueidentifier) as DATAELEMENT25ID
    ,CAST([26] as uniqueidentifier) as DATAELEMENT26ID
    ,CAST([27] as uniqueidentifier) as DATAELEMENT27ID
    ,CAST([28] as uniqueidentifier) as DATAELEMENT28ID
    ,CAST([29] as uniqueidentifier) as DATAELEMENT29ID
    ,CAST([30] as uniqueidentifier) as DATAELEMENT30ID
from
    (    select         
            T.c.value('(DATAELEMENTID)[1]','nvarchar(36)') AS 'DATAELEMENTID',
            T.c.value('(SEQUENCE)[1]','int') AS 'SEQUENCE'
        from @ITEMLISTXML.nodes('/JOURNALENTRYELEMENTS/ITEM') T(c)        
    ) as P
pivot
    (
        max( DATAELEMENTID )
        for SEQUENCE in ([1],[2],[3],[4],[5],[6],[7],[8],[9],[10]
                        ,[11],[12],[13],[14],[15],[16],[17],[18],[19],[20]
                        ,[21],[22],[23],[24],[25],[26],[27],[28],[29],[30]
        )
    ) as PT