USP_SIMPLEDATALIST_AVAILABLEEVENTPREFERENCEGROUP

A simple data list of event preference group records for a specific event.

Parameters

Parameter	Parameter Type	Mode	Description
@EVENTID	uniqueidentifier	IN

Definition

Copy



            create procedure dbo.USP_SIMPLEDATALIST_AVAILABLEEVENTPREFERENCEGROUP
            (
                @EVENTID uniqueidentifier = null
            ) 
            as                
                set nocount on;

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