UFN_EVENT_GETREGISTRATIONPACKAGES

Returns all registration packages for a given event.

Return

Return Type
table

Parameters

Parameter	Parameter Type	Mode	Description
@EVENTID	uniqueidentifier	IN

Definition

Copy



            CREATE function dbo.UFN_EVENT_GETREGISTRATIONPACKAGES
            (
                @EVENTID uniqueidentifier
            )
            returns table
            as
            return
            (
                    select 
                        REGISTRATIONPACKAGE.ID, 
                        REGISTRATIONPACKAGE.NAME,
                        dbo.UFN_REGISTRATIONPACKAGE_GETAMOUNT(REGISTRATIONPACKAGE.ID) [AMOUNT],
                        dbo.UFN_REGISTRATIONPACKAGE_GETRECEIPTAMOUNT(REGISTRATIONPACKAGE.ID) [RECEIPTAMOUNT]
                    from 
                        dbo.REGISTRATIONPACKAGE
                    where 
                        REGISTRATIONPACKAGE.EVENTID = @EVENTID
            );