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