UFN_BBNC_GETREGISTRANTIDFROMEVENTIDCONSTITID

Returns a constituent's registrant record for the given event for Blackbaud Internet Solutions.

Return

Return Type
uniqueidentifier

Parameters

Parameter Parameter Type Mode Description
@EVENTID uniqueidentifier IN
@CONSTITUENTID uniqueidentifier IN

Definition

Copy


            CREATE function dbo.UFN_BBNC_GETREGISTRANTIDFROMEVENTIDCONSTITID
            (
                @EVENTID uniqueidentifier,
                @CONSTITUENTID uniqueidentifier
            )
            returns uniqueidentifier
            as
            begin
                declare @ID uniqueidentifier;
                select @ID = ID from dbo.REGISTRANT where EVENTID = @EVENTID and CONSTITUENTID = @CONSTITUENTID;
                return @ID;
            end