UFN_REVENUEBATCH_GETREGISTRATION_FROMITEMLISTXML

        CREATE function dbo.UFN_REVENUEBATCH_GETREGISTRATION_FROMITEMLISTXML
        (
            @ITEMLISTXML xml
        ) returns table as
            return (
            select
                T.c.value('(EVENTID)[1]','uniqueidentifier') as 'EVENTID',
                T.c.value('(DATEPURCHASED)[1]','datetime') as 'DATEPURCHASED',
                case when T.c.exist('./PACKAGEREGISTRATIONS/ITEM') = 1 then T.c.query('(PACKAGEREGISTRATIONS)[1]') else null end as 'PACKAGEREGISTRATIONS',
                case when T.c.exist('./PACKAGESPRICES/ITEM') = 1 then T.c.query('(PACKAGESPRICES)[1]') else null end as 'PACKAGESPRICES',
                case when T.c.exist('./SINGLEEVENTREGISTRATIONS/ITEM') = 1 then T.c.query('(SINGLEEVENTREGISTRATIONS)[1]') else null end as 'SINGLEEVENTREGISTRATIONS',
                T.c.value('(WAIVEBENEFITS)[1]', 'bit') as 'WAIVEBENEFITS',
                case when T.c.exist('./REGISTRANTMAPPINGS/ITEM') = 1 then T.c.query('(REGISTRANTMAPPINGS)[1]') else null end as 'REGISTRANTMAPPINGS',
                case when T.c.exist('./DELETEDREGISTRANTREGISTRATIONMAPS/ITEM') = 1 then T.c.query('(DELETEDREGISTRANTREGISTRATIONMAPS)[1]') else null end as 'DELETEDREGISTRANTREGISTRATIONMAPS'
            from @ITEMLISTXML.nodes('/REGISTRATIONS/ITEM') T(c)
              )