UFN_DISBURSEMENTPROCESS_RANGESGRID_DONOTALLOWZERO

Do not allow a range with zero (since it is not a valid check number)

Return

Return Type
bit

Parameters

Parameter	Parameter Type	Mode	Description
@RANGESGRID	xml	IN

Definition

Copy



create function dbo.UFN_DISBURSEMENTPROCESS_RANGESGRID_DONOTALLOWZERO(@RANGESGRID xml)
returns bit
with execute as caller
as begin
    declare @ReturnValue bit;
    set @ReturnValue=0;
    declare @TempTable table
    (
        [START] INT
    );

    insert into @TempTable
        select 
            [RANGESTART]
        from dbo.UFN_DISBURSEMENTPROCESSFORMNUMBERRANGE_FROMITEMLISTXML(@RANGESGRID);

    if exists
    (
        select [START] from @TempTable where [START] = 0
    )    
    set @ReturnValue = 1

    return @ReturnValue;
end