USP_DATAFORMTEMPLATE_VIEW_WEALTHPOINTSUBSCRIPTIONINFO

Parameters

Parameter	Parameter Type	Mode
@DATALOADED	bit	INOUT
@ORGNAME	nvarchar(200)	INOUT
@SITEID	nvarchar(100)	INOUT
@SUBSCRIPTION	nvarchar(24)	INOUT

Definition

Copy


CREATE procedure dbo.USP_DATAFORMTEMPLATE_VIEW_WEALTHPOINTSUBSCRIPTIONINFO
(
    @DATALOADED bit = 0 output,
    @ORGNAME nvarchar(200) = null output,
    @SITEID nvarchar(100) = null output,
    @SUBSCRIPTION nvarchar(24) = null output
)
as
    set nocount on;

  select
      @ORGNAME = INSTALLATIONNAME, 
      @SITEID = CLARIFYSITEID 
  from INSTALLATIONINFO

  select
      @SUBSCRIPTION = ACCOUNTTYPE
  from WEALTHPOINTCONFIGURATION

    set @DATALOADED = 1;
    return 0;