UFN_BANKACCOUNTAUTHORIZEDSIGNATURE_SIGNATUREUNIQUE

This function checks to make sure the signature name does not already exist as an authorized signature on a bank account

Return

Return Type
bit

Parameters

Parameter	Parameter Type	Mode
@BANKACCOUNTID	uniqueidentifier	IN
@MANUALSIGNATURENAME	nvarchar(255)	IN
@SIGNATUREID	uniqueidentifier	IN

Definition

Copy



            create function dbo.UFN_BANKACCOUNTAUTHORIZEDSIGNATURE_SIGNATUREUNIQUE
            (
                @BANKACCOUNTID uniqueidentifier,
                @MANUALSIGNATURENAME nvarchar(255),
                @SIGNATUREID uniqueidentifier
            )

            returns bit
            with execute as caller
            as begin

            declare @COUNT integer

             select @COUNT = count(MANUALSIGNATURENAME)    
                            from
                                dbo.BANKACCOUNTAUTHORIZEDSIGNATURE
                            where
                                BANKACCOUNTAUTHORIZEDSIGNATURE.BANKACCOUNTID = @BANKACCOUNTID and
                                BANKACCOUNTAUTHORIZEDSIGNATURE.MANUALSIGNATURENAME = @MANUALSIGNATURENAME
                                and @MANUALSIGNATURENAME <> '' 

            if @COUNT > 1
                return 1;

            select @COUNT = count(SIGNATUREID)    
                            from
                                dbo.BANKACCOUNTAUTHORIZEDSIGNATURE
                            where
                                BANKACCOUNTAUTHORIZEDSIGNATURE.BANKACCOUNTID = @BANKACCOUNTID and
                                BANKACCOUNTAUTHORIZEDSIGNATURE.SIGNATUREID = @SIGNATUREID
                                and @SIGNATUREID is not null 

            if @COUNT > 1
                return 1;


            return 0;
            end