USP_DATAFORMTEMPLATE_EDITLOAD_MANAGEKPIINSTANCEFOLDERS

Parameters

Parameter Parameter Type Mode Description
@DATALOADED bit INOUT
@TSLONG bigint INOUT
@HIERARCHY xml INOUT
@CURRENTAPPUSERID uniqueidentifier IN

Definition

Copy

CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDITLOAD_MANAGEKPIINSTANCEFOLDERS
(
  @DATALOADED bit = 0 output,
  @TSLONG bigint = 0 output,
  @HIERARCHY xml = null output,
  @CURRENTAPPUSERID uniqueidentifier = null
)
as

    set nocount on;

  select
    @TSLONG = (select max(TSLONG) from dbo.[KPIINSTANCEFOLDER]),
    @DATALOADED = 1;

    return 0;