UFN_BBNC_MEMBERSHIP_GETROWBBNCIDS

Returns a list of Blackbaud Internet Solutions transaction IDs that are part of a Blackbaud Internet Solutions membership batch.

Return

Return Type
table

Parameters

Parameter	Parameter Type	Mode	Description
@BATCHID	uniqueidentifier	IN

Definition

Copy



            CREATE function dbo.UFN_BBNC_MEMBERSHIP_GETROWBBNCIDS
            (
                @BATCHID uniqueidentifier
            )
            returns table
            as
                return
                (
                    select BBNCID
                    from dbo.BATCHMEMBERSHIPDUESBBNCINFO
                    inner join dbo.BATCHMEMBERSHIPDUES on BATCHMEMBERSHIPDUES.ID = BATCHMEMBERSHIPDUESBBNCINFO.BATCHMEMBERSHIPDUESID
                    where BATCHMEMBERSHIPDUES.BATCHID = @BATCHID
                );