UFN_ITINERARYSTAFFRESOURCE_QUANTITYVALIDFORCAPACITY

Determines if an itinerary staff resource quantity is valid for the capacity specified on the reservation.

Return

Return Type
bit

Parameters

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

Definition

Copy



            create function dbo.UFN_ITINERARYSTAFFRESOURCE_QUANTITYVALIDFORCAPACITY
            (
                @ITINERARYID uniqueidentifier,
                @VOLUNTEERTYPEID uniqueidentifier,
                @QUANTITY int
            )
            returns bit
            as begin
                declare @CAPACITY int;

                select @CAPACITY = sum(ITINERARYATTENDEE.QUANTITY)
                from dbo.ITINERARYATTENDEE
                where ITINERARYATTENDEE.ITINERARYID = @ITINERARYID;


                return dbo.UFN_STAFFRESOURCE_QUANTITYVALIDFORCAPACITY(@VOLUNTEERTYPEID, @QUANTITY, @CAPACITY);
            end