USP_SIMPLEDATALIST_FAFNFGSBYEVENT

create procedure dbo.USP_SIMPLEDATALIST_FAFNFGSBYEVENT
(
  @EVENTID as uniqueidentifier
)
as
    select 
        FNC.ID as VALUE, 
        FNC.NAME as LABEL
    from dbo.EVENTEXTENSION EE
  INNER JOIN FAFNFGCAMPAIGN FNC ON EE.FAFPROGRAMID = FNC.CAMPAIGNID
  WHERE EE.EVENTID=@EVENTID
    order by FNC.NAME