USP_RECORDOPERATION_WEALTHCAPACITYFORMULARECALCULATESELECTIONPROMPT

Provides the prompt for the "Wealth Capacity Formula: Recalculate Selection" record operation.
Parameters

Parameter	Parameter Type	Mode	Description
@ID	nchar	IN	Represents information to be displayed in the record operation prompt.
@COUNT	int	INOUT
@LOCKEDCOUNT	int	INOUT
Definition

Copy


                            CREATE procedure dbo.USP_RECORDOPERATION_WEALTHCAPACITYFORMULARECALCULATESELECTIONPROMPT (
                                @ID nchar(72),
                                @COUNT int output,
                                @LOCKEDCOUNT int output
                            ) as
                                set nocount on;

                                declare @WEALTHCAPACITYFORMULAID uniqueidentifier;
                                declare @IDSETREGISTERID uniqueidentifier;
                                declare @VALIDIDS bit;

                                begin try
                                    set @WEALTHCAPACITYFORMULAID = convert(uniqueidentifier,substring(@ID,0,37));
                                    set @IDSETREGISTERID = convert(uniqueidentifier,substring(@ID,37,37));
                                    set @VALIDIDS = 1;
                                end try
                                begin catch
                                    set @VALIDIDS = 0;
                                end catch

                                if @VALIDIDS = 1 begin
                                    select
                                        @COUNT = count(WC.ID)
                                    from
                                        dbo.UFN_IDSETREADER_GETRESULTS_GUID(@IDSETREGISTERID) IDSET
                                    left join
                                        dbo.WEALTHCAPACITY WC
                                    on
                                        WC.ID = IDSET.ID
                                    where
                                        WC.WEALTHCAPACITYFORMULAID = @WEALTHCAPACITYFORMULAID and
                                        WC.CONFIRMED = 0;

                                    select
                                        @LOCKEDCOUNT = count(WC.ID)
                                    from
                                        dbo.UFN_IDSETREADER_GETRESULTS_GUID(@IDSETREGISTERID) IDSET
                                    left join
                                        dbo.WEALTHCAPACITY WC
                                    on
                                        WC.ID = IDSET.ID
                                    where
                                        WC.CONFIRMED = 1;
                                end

                                return 0;