USP_SIMPLEDATALIST_EVENT_REGISTRATIONOPTION

A simple data list of registration option records for a specific event.

Parameters

Parameter	Parameter Type	Mode	Description
@EVENTID	uniqueidentifier	IN
@EVENTLOOKUPID	nvarchar(100)	IN

Definition

Copy



                CREATE procedure dbo.USP_SIMPLEDATALIST_EVENT_REGISTRATIONOPTION
                (
                    @EVENTID uniqueidentifier = null,
                    @EVENTLOOKUPID nvarchar(100) = ''
                )
                as
                    set nocount on;

                    if (@EVENTID is null) and (len(@EVENTLOOKUPID) > 0)
                        select @EVENTID = ID from dbo.EVENT where LOOKUPID = @EVENTLOOKUPID

                    select
                        EVENTPRICE.ID as VALUE,
                        EVENTPRICE.NAME as LABEL 
                    from 
                        dbo.EVENTPRICE
                    where 
                        EVENTID = @EVENTID
                    order by 
                        EVENTPRICE.NAME;