UFN_BBNC_NAMEFORMATS_FROMITEMLISTXML

Returns a table containing all name formats defined for a constituent for Blackbaud Internet Solutions.

Return

Return Type
table

Parameters

Parameter	Parameter Type	Mode	Description
@ITEMLISTXML	xml	IN

Definition

Copy



            CREATE function dbo.UFN_BBNC_NAMEFORMATS_FROMITEMLISTXML(@ITEMLISTXML xml) 
            returns table
            as
            return (
                select
                    T.c.value('(TYPE)[1]','nvarchar(max)') AS 'TYPE',
                    T.c.value('(VALUE)[1]','nvarchar(max)') AS 'VALUE'
                FROM   
                    @ITEMLISTXML.nodes('/NAMEFORMATS/ITEM') T(c)            
                    )