UFN_GIFTFEEPAYMENTMETHOD_UNIQUE

Validates that values are unique for the gift fee payment method table.

Return

Return Type
bit

Parameters

Parameter Parameter Type Mode Description
@PAYMENTMETHODCODE tinyint IN

Definition

Copy


            create function dbo.UFN_GIFTFEEPAYMENTMETHOD_UNIQUE (@PAYMENTMETHODCODE tinyint
            returns bit
            with execute as caller
            as 
            begin
                declare @r as int;
                select @r = count(*) from dbo.GIFTFEEPAYMENTMETHOD where PAYMENTMETHODCODE = @PAYMENTMETHODCODE;

                if @r <= 1 --No others

                    return 1

                return 0
            end