UFN_REGISTRANT_GUESTCOUNT

Returns a registrant's number of guests.

Return

Return Type
int

Parameters

Parameter	Parameter Type	Mode	Description
@REGISTRANTID	uniqueidentifier	IN

Definition

Copy



            create function dbo.UFN_REGISTRANT_GUESTCOUNT
            (
                @REGISTRANTID uniqueidentifier = null
            ) 
            returns int
            with execute as caller
            as
            begin
                declare @GUESTCOUNT int;

                select
                    @GUESTCOUNT = count(ID)
                from
                    dbo.REGISTRANT
                where
                    GUESTOFREGISTRANTID = @REGISTRANTID;

                return @GUESTCOUNT;
            end