UFN_EVENT_GETAVAILABILITY

Returns the number of tickets available for a scheduled event.

Return

Return Type
int

Parameters

Parameter	Parameter Type	Mode	Description
@EVENTID	uniqueidentifier	IN

Definition

Copy



        CREATE function dbo.UFN_EVENT_GETAVAILABILITY 
        (
            @EVENTID uniqueidentifier
        )
        returns int
        as begin
            declare @AVAILABILITY int;
            select @AVAILABILITY = AVAILABILITY from dbo.V_PROGRAMEVENT_TICKETCOUNTS where ID = @EVENTID;
            return @AVAILABILITY;
        end