USP_DATAFORMTEMPLATE_VIEW_SIMPLEACKNOWLEDGEMENTPAGEEXPRESSION

The load procedure used by the view dataform template "Acknowledgement Expression 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.
@COUNT	int	INOUT	COUNT
@MKTSEGMENTATIONACTIVATEPROCESSID	uniqueidentifier	INOUT	MKTSEGMENTATIONACTIVATEPROCESSID
@SEGMENTATIONID	uniqueidentifier	INOUT	SEGMENTATIONID
@ARCHIVEDLETTERSCOUNT	int	INOUT	ARCHIVEDLETTERSCOUNT
@NAME	nvarchar(100)	INOUT

Definition

Copy


CREATE procedure dbo.USP_DATAFORMTEMPLATE_VIEW_SIMPLEACKNOWLEDGEMENTPAGEEXPRESSION
(
    @ID uniqueidentifier,
    @DATALOADED bit = 0 output,  
    @COUNT int = null output,
    @MKTSEGMENTATIONACTIVATEPROCESSID uniqueidentifier = null output,
  @SEGMENTATIONID uniqueidentifier = null output, 
  @ARCHIVEDLETTERSCOUNT int = null output,
  @NAME nvarchar(100) = null output
)
as
    set nocount on;

    set @DATALOADED = 0;

    select   
        @DATALOADED = 1,
        @COUNT = (select count(ID) from dbo.COMMUNICATIONLETTER where SEGMENTATIONID = @ID),
        @MKTSEGMENTATIONACTIVATEPROCESSID = MKTSEGMENTATIONACTIVATEPROCESS.ID, 
        @SEGMENTATIONID = MKTSEGMENTATION.ID,
        @ARCHIVEDLETTERSCOUNT = (select count(LETTERCODE.ID) from dbo.LETTERCODE where IDSETREGISTERID is not null and ISSYSTEM = 0) + (select COUNT(ID) from dbo.TRIBUTEACKNOWLEDGEMENTPROCESS),
        @NAME = MKTSEGMENTATION.NAME
    from 
    dbo.MKTSEGMENTATION
    left outer join dbo.MKTSEGMENTATIONACTIVATEPROCESS on MKTSEGMENTATIONACTIVATEPROCESS.SEGMENTATIONID = MKTSEGMENTATION.ID
    where 
    MKTSEGMENTATION.ID = @ID;

    return 0;