USP_RECORDOPERATION_WEALTHCAPACITYFORMULARECALCULATECONSTITUENTSPROMPT
Provides the prompt for the "Wealth Capacity Formula: Recalculate Constituents" record operation.
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @ID | uniqueidentifier | IN | Represents information to be displayed in the record operation prompt. |
| @COUNT | int | INOUT | |
| @LOCKEDCOUNT | int | INOUT |
Definition
Copy
CREATE procedure dbo.USP_RECORDOPERATION_WEALTHCAPACITYFORMULARECALCULATECONSTITUENTSPROMPT (
@ID uniqueidentifier,
@COUNT int output,
@LOCKEDCOUNT int output
) as
set nocount on;
select
@COUNT = count(WC.ID)
from
dbo.WEALTHCAPACITY WC
where
WC.WEALTHCAPACITYFORMULAID = @ID and
WC.CONFIRMED = 0;
select
@LOCKEDCOUNT = count(WC.ID)
from
dbo.WEALTHCAPACITY WC
where
WC.WEALTHCAPACITYFORMULAID = @ID and
WC.CONFIRMED = 1;
return 0;