UFN_BBNC_SIGNUP_GETROWBBNCIDS

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

Return

Return Type
table

Parameters

Parameter	Parameter Type	Mode	Description
@BATCHID	uniqueidentifier	IN

Definition

Copy



            CREATE function dbo.UFN_BBNC_SIGNUP_GETROWBBNCIDS
            (
                @BATCHID uniqueidentifier
            )
            returns table
            as
                return
                (
                    select
                        bbnc.BBNCID as VALUE
                    from
                        dbo.BATCHCONSTITUENTUPDATE cub inner join
                        dbo.BATCHCONSTITUENTUPDATEBBNCINFO bbnc on cub.ID = bbnc.BATCHCONSTITUENTUPDATEID
                    where
                        BATCHID = @BATCHID
                );