USP_SIMPLEDATALIST_FAF_REGISTRATIONOPTIONS_REPORT

CREATE PROCEDURE USP_SIMPLEDATALIST_FAF_REGISTRATIONOPTIONS_REPORT
( @EventID as uniqueidentifier = null )
AS
BEGIN
    SET NOCOUNT ON;

    declare @evtchoice table
    (
      names nvarchar(50)
    ) 
    insert into @evtchoice values ('All')

  insert into @evtchoice
  select distinct EVENTPRICE.NAME from EVENTPRICE
  join EVENT on EVENT.ID = EVENTPRICE.EVENTID
  where EVENT.ISACTIVE <> 0    
  and EVENTPRICE.EVENTID = @EventID

  select names value
  from @evtchoice

END