UFN_BBNC_ATTRIBUTES_FROMITEMLISTXML

Returns a table containing all attributes 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_ATTRIBUTES_FROMITEMLISTXML(@ITEMLISTXML xml) 
            returns table
            as
            return (
                select
                    T.c.value('(ATTRIBUTETYPEID)[1]','int') AS 'ATTRIBUTETYPEID',
                    T.c.value('(VALUE)[1]','nvarchar(max)') AS 'VALUE',
                    T.c.value('(TABLEENTRYID)[1]','uniqueidentifier') AS 'TABLEENTRYID',
                    T.c.value('(BOOLEANCODE)[1]','tinyint') AS 'BOOLEANCODE',
                    T.c.value('(CURRENCYID)[1]','uniqueidentifier') AS 'CURRENCYID'
                FROM   
                    @ITEMLISTXML.nodes('/ATTRIBUTES/ITEM') T(c)            
                    )