USP_GETEVENTPREFERENCES

CREATE PROCEDURE DBO.USP_GETEVENTPREFERENCES
(
    @EVENTID as nvarchar(50)
)
as
begin
    select 
         NAME as EVENTPREFERENCENAME,
         ID as EVENTPREFERENCEID
    from dbo.EVENTPREFERENCEGROUP
    where EVENTID =@EVENTID
    order by DATEADDED asc
end