USP_SIMPLEDATALIST_NEXTFIVEEVENTSFORPROGRAMEVENT

create procedure dbo.USP_SIMPLEDATALIST_NEXTFIVEEVENTSFORPROGRAMEVENT
(
    @EVENTID uniqueidentifier = null
)
as begin

    select
        @EVENTID as VALUE,
        dbo.UFN_TRANSLATIONFUNCTION_EVENTFORRESCHEDULE(@EVENTID) as LABEL

    union all

    select VALUE, LABEL
    from (
        select top 5
            UPCOMINGEVENT.ID as VALUE,
            dbo.UFN_TRANSLATIONFUNCTION_EVENTFORRESCHEDULE(UPCOMINGEVENT.ID) as LABEL
        from dbo.[EVENT]
        inner join dbo.[EVENT] UPCOMINGEVENT on (UPCOMINGEVENT.PROGRAMID = [EVENT].PROGRAMID and UPCOMINGEVENT.ID <> [EVENT].ID)
        where UPCOMINGEVENT.STARTDATETIME >= getdate()
            and [EVENT].ID = @EVENTID
        order by UPCOMINGEVENT.STARTDATETIME
    ) UPCOMINGEVENTS;
end