UFN_VOLUNTEERSKILLLEVEL_FROMITEMLISTXML

Returns all active volunteer types for a given volunteer

Return

Return Type
table

Parameters

Parameter	Parameter Type	Mode	Description
@ITEMLISTXML	xml	IN

Definition

Copy



            create function dbo.UFN_VOLUNTEERSKILLLEVEL_FROMITEMLISTXML(@ITEMLISTXML xml) 
            returns table as
            return (
            select
                T.c.value('(ID)[1]','uniqueidentifier') AS 'ID',
                T.c.value('(SEQUENCE)[1]','int') AS 'SEQUENCE',
                T.c.value('(DESCRIPTION)[1]','nvarchar(25)') AS 'DESCRIPTION'
            FROM  @ITEMLISTXML.nodes('/SKILLLEVELS/ITEM') T(c)
            )