USP_MAJORGIVINGCAPACITY_GETRANGE
Returns a major giving capacity range for a specific id.
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @ID | uniqueidentifier | IN | |
| @MINAMOUNT | money | INOUT | |
| @MAXAMOUNT | money | INOUT |
Definition
Copy
create procedure dbo.USP_MAJORGIVINGCAPACITY_GETRANGE(
@ID uniqueidentifier,
@MINAMOUNT money output,
@MAXAMOUNT money output
)as
set nocount on;
with
MAJORGIVINGCAPACITY_MIN as (
select
MAJORGIVINGCAPACITY.[ID] ID,
MAJORGIVINGCAPACITY.[MINIMUMAMOUNT] MINAMOUNT,
ROW_NUMBER() over (order by MAJORGIVINGCAPACITY.[MINIMUMAMOUNT]) ROWNUMBER
from
dbo.[MAJORGIVINGCAPACITY]
),
MAJORGIVINGCAPACITY_MIN_MAX as (
select
MAJORGIVINGCAPACITY_MIN.[ID],
MAJORGIVINGCAPACITY_MIN.[MINAMOUNT],
( select
[MINAMOUNT] - 1.00
from
MAJORGIVINGCAPACITY_MIN SUB
where
SUB.[ROWNUMBER] = MAJORGIVINGCAPACITY_MIN.[ROWNUMBER] + 1
) MAXAMOUNT
from
MAJORGIVINGCAPACITY_MIN
)
select
@MINAMOUNT = MAJORGIVINGCAPACITY_MIN_MAX.[MINAMOUNT],
@MAXAMOUNT = MAJORGIVINGCAPACITY_MIN_MAX.[MAXAMOUNT]
from
MAJORGIVINGCAPACITY_MIN_MAX
where
MAJORGIVINGCAPACITY_MIN_MAX.[ID] = @ID;