UFN_BBNC_PROFILEUPDATE_GETROWBBNCIDS

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

Return

Return Type
table

Parameters

Parameter	Parameter Type	Mode	Description
@BATCHID	uniqueidentifier	IN

Definition

Copy



            CREATE function dbo.UFN_BBNC_PROFILEUPDATE_GETROWBBNCIDS
            (
                @BATCHID uniqueidentifier
            )
            returns table
            as
                return
                (
                    select
                        [BBNCID]
                    from
                        dbo.BATCHBBNCPROFILE
                    where
                        [BATCHID] = @BATCHID
                );