USP_DATAFORMTEMPLATE_VIEW_MKTPREACTIVATIONSTATUS

The load procedure used by the view dataform template "Marketing Effort Record Count Status View Form"

Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	IN	The input ID parameter used to load the fields defined on the form.
@DATALOADED	bit	INOUT	Output parameter indicating whether or not data was actually loaded.
@NAME	nvarchar(50)	INOUT	Name
@STATUS	nvarchar(100)	INOUT	Status
@STATUSMESSAGE	nvarchar(max)	INOUT	Status message

Definition

Copy



CREATE procedure dbo.[USP_DATAFORMTEMPLATE_VIEW_MKTPREACTIVATIONSTATUS]
(
  @ID uniqueidentifier,
  @DATALOADED bit = 0 output,
  @NAME nvarchar(50) = null output,
  @STATUS nvarchar(100) = null output,
  @STATUSMESSAGE nvarchar(max) = null output
)
as
  set nocount on;

  set @DATALOADED = 0;

  select
    @DATALOADED = 1,
    @NAME=[BUSINESSPROCESSCATALOG].[NAME],
    @STATUS='Status: ' + [BUSINESSPROCESSSTATUS].[STATUS],
    @STATUSMESSAGE=coalesce([BUSINESSPROCESSSTATUS].[ERRORMESSAGE],'OK')
  from
    dbo.[BUSINESSPROCESSSTATUS]
  inner join
    dbo.[BUSINESSPROCESSCATALOG] on [BUSINESSPROCESSCATALOG].[ID] = [BUSINESSPROCESSSTATUS].[BUSINESSPROCESSCATALOGID]
  where
    [BUSINESSPROCESSSTATUS].[ID]= @ID;

  return 0;