UFN_EVENTSPONSOR_GETBENEFITS_FROMITEMLISTXML

create function dbo.UFN_EVENTSPONSOR_GETBENEFITS_FROMITEMLISTXML
(
    @ITEMLISTXML xml
)
returns table
as 
-- do work here and return a value

return
(
    SELECT  
        T.c.value('(BASECURRENCYID)[1]','uniqueidentifier') AS 'BASECURRENCYID',  
        T.c.value('(BENEFITID)[1]','uniqueidentifier') AS 'BENEFITID',
        T.c.value('(DETAILS)[1]','nvarchar(255)') AS 'DETAILS',  
        T.c.value('(ID)[1]','uniqueidentifier') AS 'ID',  
        T.c.value('(QUANTITY)[1]','int') AS 'QUANTITY',  
        T.c.value('(TOTALVALUE)[1]','money') AS 'TOTALVALUE',  
        T.c.value('(UNITVALUE)[1]','money') AS 'UNITVALUE'  
    FROM @ITEMLISTXML.nodes('/BENEFIT/ITEM') T(c)
)