USP_SIMPLEDATALIST_EVENTREGISTRATIONOPTION

CREATE procedure dbo.USP_SIMPLEDATALIST_EVENTREGISTRATIONOPTION(@EVENTID uniqueidentifier) as
    set nocount on;

  select
    EP.ID AS VALUE,
    EP.Name AS LABEL
  from
    dbo.EventPrice EP
  inner join dbo.FAFREGISTRATIONTYPE FR
    on EP.ID = FR.EVENTPRICEID
  WHERE
    EVENTID=@EVENTID and 
    FR.ISACTIVE=1