USP_FAF_REGISTRATIONOPTIONS_REPORT

CREATE PROCEDURE USP_FAF_REGISTRATIONOPTIONS_REPORT
(
    @EVENTID uniqueidentifier
)
AS
BEGIN
    SET NOCOUNT ON;

    declare @evtchoice table
    (
        names nvarchar(50)
    ) 
    insert into @evtchoice values ('All')
    insert into @evtchoice
    select NAME from EVENTPRICE
    where EVENTID = @EVENTID

    select names from @evtchoice

END