UFN_BATCHBBNCDONATION_GETSOLICITORS

Retrieves the solicitors for a row in a Blackbaud Internet Solutions Donations batch.

Return

Return Type
table

Parameters

Parameter	Parameter Type	Mode	Description
@BATCHBBNCDONATIONID	uniqueidentifier	IN

Definition

Copy



            CREATE function dbo.UFN_BATCHBBNCDONATION_GETSOLICITORS
            (
                @BATCHBBNCDONATIONID uniqueidentifier
            )
            returns table
            as
            return
            (
                select
                    ID,
                    BATCHBBNCDONATIONID,
                    FUNDRAISERID,
                    SEQUENCE                    
                from dbo.BATCHBBNCDONATIONSOLICITOR
                where BATCHBBNCDONATIONID = @BATCHBBNCDONATIONID
            )