USP_DATALIST_EVENTAPPEALS

Displays the appeals for the given event.

Parameters

Parameter	Parameter Type	Mode	Description
@EVENTID	uniqueidentifier	IN	Input parameter indicating the context ID for the data list.

Definition

Copy



CREATE procedure dbo.USP_DATALIST_EVENTAPPEALS
(
    @EVENTID uniqueidentifier
) as
    set nocount on;

    select
        EVENTAPPEAL.ID,
        EVENTAPPEAL.APPEALID,
        APPEAL.NAME,
        APPEAL.STARTDATE,
        APPEAL.ENDDATE,
        APPEAL.GOAL,
        APPEAL.BASECURRENCYID

    from
        dbo.EVENTAPPEAL
        inner join dbo.APPEAL on APPEAL.ID = EVENTAPPEAL.APPEALID
    where
        EVENTAPPEAL.EVENTID = @EVENTID
    order by
        APPEAL.NAME;