UFN_EVENT_GETAPPEALS

Returns all appeals for a given event record.

Return

Return Type
table

Parameters

Parameter	Parameter Type	Mode	Description
@EVENTID	uniqueidentifier	IN

Definition

Copy



create function dbo.UFN_EVENT_GETAPPEALS
(
    @EVENTID uniqueidentifier
) returns table as
    return (
        select
            ID,
            APPEALID
        from
            dbo.EVENTAPPEAL
        where
            EVENTID = @EVENTID
        );