USP_DATAFORMTEMPLATE_VIEW_DATABASEGROWTHANALYSISPROCESSSTATUS

Parameters

Parameter	Parameter Type	Mode
@ID	uniqueidentifier	IN
@CURRENTAPPUSERID	uniqueidentifier	IN
@DATALOADED	bit	INOUT
@NAME	nvarchar(128)	INOUT
@LASTRUN	datetime	INOUT
@STARTEDBY	nvarchar(255)	INOUT
@STATUSCODE	tinyint	INOUT
@NUMBERPROCESSED	int	INOUT

Definition

Copy


create procedure dbo.[USP_DATAFORMTEMPLATE_VIEW_DATABASEGROWTHANALYSISPROCESSSTATUS]
(
  @ID uniqueidentifier,
  @CURRENTAPPUSERID uniqueidentifier,
  @DATALOADED bit = 0 output,
  @NAME nvarchar(128) = null output,
  @LASTRUN datetime = null output,
  @STARTEDBY nvarchar(255) = null output,
  @STATUSCODE tinyint = null output,
  @NUMBERPROCESSED integer = null output
)
as begin
  set nocount on;

  select top 1
    @DATALOADED = 1,
    @NAME = [DATABASEGROWTHANALYSISPROCESS].[NAME],
    @LASTRUN = case when [BUSINESSPROCESSSTATUS].[STATUSCODE] = 0 then [BUSINESSPROCESSSTATUS].[ENDEDON] else null end,
    @STARTEDBY = case when [APPUSER].[DISPLAYNAME] = '' then [APPUSER].[USERNAME] else [APPUSER].[DISPLAYNAME] end,
    @STATUSCODE = [BUSINESSPROCESSSTATUS].[STATUSCODE],
    @NUMBERPROCESSED = [BUSINESSPROCESSSTATUS].[NUMBERPROCESSED]
  from dbo.[DATABASEGROWTHANALYSISPROCESS]
  left outer join dbo.[BUSINESSPROCESSSTATUS] on [BUSINESSPROCESSSTATUS].[BUSINESSPROCESSPARAMETERSETID] = [DATABASEGROWTHANALYSISPROCESS].[ID]
  left outer join dbo.[APPUSER] on [APPUSER].[ID] = [BUSINESSPROCESSSTATUS].[STARTEDBYUSERID]
  where ([DATABASEGROWTHANALYSISPROCESS].[ID] = @ID or [BUSINESSPROCESSSTATUS].[ID] = @ID)
  order by [BUSINESSPROCESSSTATUS].[DATEADDED] desc;

  return 0;
end