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