UFN_ITINERARYITEMSTAFFRESOURCE_QUANTITYVALIDFORCAPACITY

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

Return

Return Type
bit

Parameters

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

Definition

Copy



            create function dbo.UFN_ITINERARYITEMSTAFFRESOURCE_QUANTITYVALIDFORCAPACITY
            (
                @ITINERARYITEMID uniqueidentifier,
                @VOLUNTEERTYPEID uniqueidentifier,
                @QUANTITY int
            )
            returns bit
            with execute as caller
            as begin
                declare @ITINERARYID uniqueidentifier;

                select @ITINERARYID = ITINERARYITEM.ITINERARYID
                from dbo.ITINERARYITEM
                where ITINERARYITEM.ID = @ITINERARYITEMID;

                return dbo.UFN_ITINERARYSTAFFRESOURCE_QUANTITYVALIDFORCAPACITY(@ITINERARYID, @VOLUNTEERTYPEID, @QUANTITY);
            end