UFN_SALESDEPOSITPROCESS_TEMPLATECURRENCY_FROMITEMLISTXML

create function dbo.UFN_SALESDEPOSITPROCESS_TEMPLATECURRENCY_FROMITEMLISTXML(
    @ITEMLISTXML xml
)
RETURNS TABLE AS
RETURN (
    select
        T.c.value('(ID)[1]', 'uniqueidentifier') as 'ID',
    T.c.value('(SALESDEPOSITTEMPLATEID)[1]', 'uniqueidentifier') as 'SALESDEPOSITTEMPLATEID',
        T.c.value('(CURRENCYID)[1]', 'uniqueidentifier') as 'CURRENCYID',
        T.c.value('(CURRENCY)[1]', 'nvarchar(100)') as 'CURRENCY',
        T.c.value('(INCLUDE)[1]', 'bit') as 'INCLUDE'
    from @ITEMLISTXML.nodes('TEMPLATES/ITEM/CURRENCY/ITEM') T(c)
)