USP_SIMPLEDATALIST_NEXTFIVEEVENTSFORPROGRAM

create procedure dbo.USP_SIMPLEDATALIST_NEXTFIVEEVENTSFORPROGRAM (@PROGRAMID uniqueidentifier = null)
as begin
    select top 5
        [EVENT].ID as VALUE,
        dbo.UFN_TRANSLATIONFUNCTION_EVENTFORRESCHEDULE([EVENT].ID) as LABEL
    from dbo.V_PROGRAMEVENT_TICKETCOUNTS TICKETCOUNTS
    inner join dbo.[EVENT] on [EVENT].ID = TICKETCOUNTS.ID
    where [EVENT].STARTDATETIME >= getdate()
        and [EVENT].PROGRAMID = @PROGRAMID
    order by STARTDATE;
end