USP_SIMPLEDATALIST_AVAILABLEREGISTRATIONPACKAGE

A simple data list of registration packages for a specific event.

Parameters

Parameter	Parameter Type	Mode	Description
@MAINEVENTID	uniqueidentifier	IN

Definition

Copy



                create procedure dbo.USP_SIMPLEDATALIST_AVAILABLEREGISTRATIONPACKAGE
                (
                    @MAINEVENTID uniqueidentifier = null
                )
                as
                    set nocount on;

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