UFN_BATCHBBNCMEMBERSHIP_GETMEMBERS

Retrieves the members for a row in a Blackbaud Internet Solutions membership batch.

Return

Return Type
table

Parameters

Parameter	Parameter Type	Mode	Description
@BATCHBBNCMEMBERSHIPID	uniqueidentifier	IN

Definition

Copy



            CREATE function dbo.UFN_BATCHBBNCMEMBERSHIP_GETMEMBERS
            (
                @BATCHBBNCMEMBERSHIPID uniqueidentifier
            )
            returns table
            as
            return
            (
                select
                    ID,
                    case when MEMBERID = '00000000-0000-0000-0000-000000000000' then null else MEMBERID end as [MEMBERID],
                    case when MEMBERCONSTITUENTID = '00000000-0000-0000-0000-000000000000' then null else MEMBERCONSTITUENTID end as [MEMBERCONSTITUENTID],
                    MEMBERISPRIMARY,
                    MEMBERUPDATEADDRESS,
                    MEMBERADDADDRESS,
                    MEMBERMAKEADDRESSPRIMARY,
                    MEMBERADDRESSTYPECODEID,
                    MEMBERBIOINFO,
                    MEMBERBIOINFOALL,
                    MEMBERPHONETYPES,
                    MEMBERADDRESSINFO,
                    MEMBERADDRESSINFOALL,
                    SEQUENCE
                from dbo.BATCHBBNCMEMBERSHIPMEMBER
                where BATCHBBNCMEMBERSHIPID = @BATCHBBNCMEMBERSHIPID
            )