UFN_REGISTRANT_GETGUESTS

Returns all guests for a given registrant.

Return

Return Type
table

Parameters

Parameter	Parameter Type	Mode	Description
@GUESTOFREGISTRANTID	uniqueidentifier	IN

Definition

Copy



            create function dbo.UFN_REGISTRANT_GETGUESTS(@GUESTOFREGISTRANTID uniqueidentifier)
            returns table
            as
            return
            (
                select 
                    ID, CONSTITUENTID, ATTENDED, EVENTID
                from 
                    dbo.REGISTRANT
                where 
                    REGISTRANT.GUESTOFREGISTRANTID = @GUESTOFREGISTRANTID
            )