USP_DEFAULTEVENTCAPACITY

Returns the default event capacity for the event.

Parameters

Parameter	Parameter Type	Mode	Description
@PROGRAMID	uniqueidentifier	IN
@MINCAPACITY	int	INOUT

Definition

Copy



            create procedure dbo.USP_DEFAULTEVENTCAPACITY
            (
                @PROGRAMID uniqueidentifier,
                @MINCAPACITY integer=null output
            )
            as

            begin


            select @MINCAPACITY=min(CAPACITY)
            from dbo.EVENTLOCATION
            inner join dbo.PROGRAMLOCATION 
            on PROGRAMLOCATION.EVENTLOCATIONID=EVENTLOCATION.ID
            where PROGRAMLOCATION.ISDEFAULT=1
            and PROGRAMLOCATION.PROGRAMID=@PROGRAMID;


            return 0;
            end;