UFN_MEMBERSHIPDUESBATCH_GETMEMBERSHIPPROGRAMADDONS_FROMITEMLISTXML

CREATE function dbo.UFN_MEMBERSHIPDUESBATCH_GETMEMBERSHIPPROGRAMADDONS_FROMITEMLISTXML
(
    @MEMBERSHIPPROGRAMADDONS xml
)
returns table
as
return (
    select
        T.c.value('(APPLY)[1]','bit') as APPLY,
        T.c.value('(ADDONID)[1]','uniqueidentifier') as ADDONID,
        T.c.value('(ADDONTYPE)[1]','tinyint') as ADDONTYPE,
        T.c.value('(PRICE)[1]','money') as PRICE,
        T.c.value('(NUMBEROFADDONS)[1]','smallint') as NUMBEROFADDONS,
        T.c.value('(MULTIPLEALLOWED)[1]','bit') as MULTIPLEALLOWED,
        T.c.value('(TRANSACTIONCURRENCYID)[1]','uniqueidentifier') as TRANSACTIONCURRENCYID
    from @MEMBERSHIPPROGRAMADDONS.nodes('/MEMBERSHIPPROGRAMADDON/ITEM') T(c)
)