USP_DATAFORMTEMPLATE_VIEW_CHARITABLEGIVINGBREAKDOWNTOOLTIP
The load procedure used by the view dataform template "Charitable Giving Breakdown Tooltip View"
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @DATALOADED | bit | INOUT | Output parameter indicating whether or not data was actually loaded. |
| @APPLICATIONNAME | nvarchar(200) | INOUT | APPLICATIONNAME |
| @APPLICATIONAMOUNT | decimal(18, 0) | INOUT | APPLICATIONAMOUNT |
| @PERCENT | decimal(18, 0) | INOUT | PERCENT |
| @CURRENCYID | uniqueidentifier | INOUT |
Definition
Copy
CREATE procedure dbo.USP_DATAFORMTEMPLATE_VIEW_CHARITABLEGIVINGBREAKDOWNTOOLTIP
(
@DATALOADED bit = 0 output,
@APPLICATIONNAME nvarchar(200) = null output,
@APPLICATIONAMOUNT decimal = null output,
@PERCENT decimal = null output,
@CURRENCYID uniqueidentifier = null output
)
as
set nocount on;
select @CURRENCYID = ID from dbo.CURRENCY where ISORGANIZATIONCURRENCY = 1;
set @DATALOADED = 1;
return 0;