USP_KPI_REVENUE_SELECTIONMONEYTOTAL
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @VALUE | money | INOUT | |
| @ASOFDATE | datetime | IN | |
| @SELECTIONID | uniqueidentifier | IN | |
| @AGGREGATENAME | nvarchar(10) | IN | |
| @CURRENCYID | uniqueidentifier | IN |
Definition
Copy
CREATE procedure dbo.USP_KPI_REVENUE_SELECTIONMONEYTOTAL
@VALUE money output,
@ASOFDATE datetime,
@SELECTIONID uniqueidentifier,
@AGGREGATENAME nvarchar(10) = 'SUM', --Possible values SUM,AVG,MIN,MAX,
@CURRENCYID uniqueidentifier = null
as
set nocount on;
declare @r int;
exec @r=dbo.USP_KPI_REVENUE_SELECTIONMONEYTOTAL_INTERNAL_2_WITHIDSET @IDSETID=@SELECTIONID, @ASOFDATE=@ASOFDATE, @TOTAL=@VALUE output, @AGGREGATENAME=@AGGREGATENAME, @CURRENCYID=@CURRENCYID;
return @r;