USP_SIMPLEDATALIST_EVENTRESTRICTIONOPTION

                CREATE procedure dbo.USP_SIMPLEDATALIST_EVENTRESTRICTIONOPTION
                (   
                    @EVENTRESTRICTIONTYPEID uniqueidentifier = null
                )
                    as
                    select 
                        EVENTRESTRICTIONOPTION.ID as VALUE, 
                        EVENTRESTRICTIONOPTION.NAME as LABEL
                    from dbo.EVENTRESTRICTIONOPTION
                    inner join dbo.EVENTRESTRICTIONTYPE
                        on EVENTRESTRICTIONTYPE.ID = EVENTRESTRICTIONOPTION.EVENTRESTRICTIONTYPEID
                    where (EVENTRESTRICTIONTYPE.ID = @EVENTRESTRICTIONTYPEID or @EVENTRESTRICTIONTYPEID is null)
                    order by EVENTRESTRICTIONOPTION.NAME