UFN_INSTALLMENTSPLIT_VALIDFORPLEDGE

Validates whether the installment split id valid for the specified pledge id.

Return

Return Type
bit

Parameters

Parameter	Parameter Type	Mode	Description
@INSTALLMENTSPLITID	uniqueidentifier	IN
@PLEDGEID	uniqueidentifier	IN

Definition

Copy



            create function dbo.UFN_INSTALLMENTSPLIT_VALIDFORPLEDGE
            (
                @INSTALLMENTSPLITID uniqueidentifier, 
                @PLEDGEID uniqueidentifier
            ) 
            returns bit 
            with execute as caller
            as
            begin
                declare @r as integer;

                select @r=count(INSTALLMENTSPLIT.ID) 
                from dbo.INSTALLMENTSPLIT
                where PLEDGEID = @PLEDGEID 
                    and ID = @INSTALLMENTSPLITID;

                if @r > 0 
                    return 1;

                return 0;
            end