USP_SIMPLEDATALIST_AVAILABLEEVENTPREFERENCE

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

Parameters

Parameter	Parameter Type	Mode	Description
@EVENTPREFERENCEGROUPID	uniqueidentifier	IN

Definition

Copy



            create procedure dbo.USP_SIMPLEDATALIST_AVAILABLEEVENTPREFERENCE
            (
                @EVENTPREFERENCEGROUPID uniqueidentifier = null
            ) 
            as                
                set nocount on;

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