USP_SIMPLEDATALIST_APPEAL2

CREATE procedure dbo.USP_SIMPLEDATALIST_APPEAL2
(
  @CURRENTAPPUSERID uniqueidentifier,
  @EVENTID uniqueidentifier
)as
    select 
                    APPEAL.ID as VALUE, 
                    APPEAL.NAME as LABEL 
                from 
                    dbo.APPEAL 
          left join dbo.EVENT on APPEAL.ID = EVENT.APPEALID
          where dbo.UFN_SITEALLOWEDFORUSER(@CURRENTAPPUSERID, APPEAL.SITEID) = 1 and (EVENT.ID is null or EVENT.ID = @EVENTID)