USP_DATAFORMTEMPLATE_ADD_FENXTADDACCOUNTSTRUCTURE_PRELOAD

Parameters

Parameter	Parameter Type	Mode
@PDACCOUNTSYSTEMID	uniqueidentifier	IN
@TOTALACCOUNTS	int	INOUT
@PROJECTACCOUNTS	int	INOUT
@PROJECTACCOUNTPERCENT	tinyint	INOUT

Definition

Copy



                    CREATE procedure dbo.USP_DATAFORMTEMPLATE_ADD_FENXTADDACCOUNTSTRUCTURE_PRELOAD
                    (
                        @PDACCOUNTSYSTEMID uniqueidentifier,
                        @TOTALACCOUNTS int = null output,
                        @PROJECTACCOUNTS int = null output,
                        @PROJECTACCOUNTPERCENT tinyint = null output
                    )
                    as
                        set nocount on;

                        select 
                            @PROJECTACCOUNTS = sum(PROJECTREQUIRED-1),
                            @TOTALACCOUNTS = count(*)
                        from dbo.FENXTACCOUNT
                        where PDACCOUNTSYSTEMID = @PDACCOUNTSYSTEMID
                            and PROJECTREQUIRED > 0;

                        select @PROJECTACCOUNTPERCENT = @PROJECTACCOUNTS*100/@TOTALACCOUNTS

                        return 0;