UFN_GIFTFEECONSTITUENCY_USERDEFINEDUNIQUE

Validates that user defined values are unique for the gift fee constituency table.

Return

Return Type
bit

Parameters

Parameter Parameter Type Mode Description
@USERCONSTITUENCYCODEID uniqueidentifier IN

Definition

Copy


            create function dbo.UFN_GIFTFEECONSTITUENCY_USERDEFINEDUNIQUE (@USERCONSTITUENCYCODEID uniqueidentifier) 
            returns bit
            with execute as caller
            as 
            begin
                declare @r as int;
                select @r = count(*) from dbo.GIFTFEECONSTITUENCY where USERCONSTITUENCYCODEID = @USERCONSTITUENCYCODEID;

                if @r <= 1 --No others

                    return 1

                return 0
            end