UFN_RESOURCE_QUANTITYNEEDED_GREATERTHANZERO

This function validates the resource quantity for non-per ticket resources is greater than zero

Return

Return Type
int

Parameters

Parameter	Parameter Type	Mode	Description
@RESOURCEID	uniqueidentifier	IN
@QUANTITY	int	IN

Definition

Copy



            create function dbo.UFN_RESOURCE_QUANTITYNEEDED_GREATERTHANZERO(@RESOURCEID uniqueidentifier, @QUANTITY int)
            returns int
            as
            begin
                return (
                    select CASE
                        WHEN ISPERTICKETITEM = 0 and @QUANTITY <= 0 THEN 0
                        ELSE 1
                        END
                    from RESOURCE
                    where ID = @RESOURCEID
                )
            end