UFN_STAFFRESOURCE_QUANTITYVALIDFORCAPACITY

Checks that the capacity and quantity passed in are valid for the given resource.

Return

Return Type
bit

Parameters

Parameter	Parameter Type	Mode
@VOLUNTEERTYPEID	uniqueidentifier	IN
@QUANTITY	int	IN
@CAPACITY	int	IN

Definition

Copy



            CREATE function dbo.UFN_STAFFRESOURCE_QUANTITYVALIDFORCAPACITY
            (
                @VOLUNTEERTYPEID uniqueidentifier, 
                @QUANTITY int,
                @CAPACITY int
            )
            returns bit
            with execute as caller
            as begin
                declare @RETVAL bit = 0;

                declare @CAPACITYPERRESOURCE int;
                select @CAPACITYPERRESOURCE = VOLUNTEERTYPE.CAPACITYPERRESOURCE 
                from dbo.VOLUNTEERTYPE 
                where VOLUNTEERTYPE.ID = @VOLUNTEERTYPEID

                if (@CAPACITYPERRESOURCE = 0) or (@CAPACITY <= (@QUANTITY * @CAPACITYPERRESOURCE))
                    set @RETVAL = 1;

                return @RETVAL;
            end