USP_DATAFORMTEMPLATE_EDITLOAD_CONSTITUENCYCRITERIAMAJORDONOR
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @DATALOADED | bit | INOUT | |
| @TSLONG | bigint | INOUT | |
| @MAJORDONORCONSTITUENCYDEFLIFETIMEAMOUNT | money | INOUT | |
| @MAJORDONORCONSTITUENCYDEFLARGESTGIFTAMOUNT | money | INOUT | |
| @DONORCURRENCYID | uniqueidentifier | INOUT |
Definition
Copy
create procedure dbo.USP_DATAFORMTEMPLATE_EDITLOAD_CONSTITUENCYCRITERIAMAJORDONOR
(
@DATALOADED bit = 0 output,
@TSLONG bigint = 0 output,
@MAJORDONORCONSTITUENCYDEFLIFETIMEAMOUNT money = null output,
@MAJORDONORCONSTITUENCYDEFLARGESTGIFTAMOUNT money = null output,
@DONORCURRENCYID uniqueidentifier = null output
)
as
set nocount on;
set @DATALOADED = 0
set @TSLONG = 0
select
@DATALOADED = 1,
@TSLONG = TSLONG,
@MAJORDONORCONSTITUENCYDEFLIFETIMEAMOUNT = MAJORDONORCONSTITUENCYDEFLIFETIMEAMOUNT,
@MAJORDONORCONSTITUENCYDEFLARGESTGIFTAMOUNT = MAJORDONORCONSTITUENCYDEFLARGESTGIFTAMOUNT,
@DONORCURRENCYID = dbo.UFN_CURRENCY_GETORGANIZATIONCURRENCY()
from
dbo.CONSTITUENCYCRITERIASPOUSE
return 0;