UFN_BATCHEVENTREGISTRANT_GETGUESTS

Returns all guests for a given batch event registrant record.

Return

Return Type
table

Parameters

Parameter	Parameter Type	Mode	Description
@BATCHEVENTREGISTRANTID	uniqueidentifier	IN

Definition

Copy


create function dbo.UFN_BATCHEVENTREGISTRANT_GETGUESTS
(
    @BATCHEVENTREGISTRANTID uniqueidentifier
)
returns table
as
return
(
    select
        [BATCHEVENTREGISTRANTGUEST].ID,
        [BATCHEVENTREGISTRANTGUEST].CONSTITUENTID,
        [BATCHEVENTREGISTRANTGUEST].WAIVEREGISTRATIONFEE,
        [BATCHEVENTREGISTRANTGUEST].ATTENDED
    from
        dbo.BATCHEVENTREGISTRANTGUEST
    where
        [BATCHEVENTREGISTRANTGUEST].BATCHEVENTREGISTRANTID = @BATCHEVENTREGISTRANTID
);