UFN_ESTIMATEDWEALTH_GETMAXIMUMAMOUNT

Return

Return Type
money

Parameters

Parameter Parameter Type Mode Description
@ID uniqueidentifier IN

Definition

Copy


            create function dbo.UFN_ESTIMATEDWEALTH_GETMAXIMUMAMOUNT(@ID uniqueidentifier)
            returns money
            as
            begin
          declare @MIN as money;

                    select    
                        @MIN = MINIMUMAMOUNT 
                    from
                        dbo.ESTIMATEDWEALTH
                    where
                        ID = @ID

                return (
                    select top 1
                        MINIMUMAMOUNT - 1
                    from
                        dbo.ESTIMATEDWEALTH
                    where
                        MINIMUMAMOUNT > @MIN
          order by
            MINIMUMAMOUNT asc
                );
            end