USP_DATAFORMTEMPLATE_VIEW_REMINDERPAGEEXPRESSION

The load procedure used by the view dataform template "Reminder Page Expression View"

Parameters

Parameter	Parameter Type	Mode	Description
@DATALOADED	bit	INOUT	Output parameter indicating whether or not data was actually loaded.
@REMINDEROPTIONID	uniqueidentifier	INOUT	REMINDEROPTIONID
@MKTSEGMENTATIONACTIVATEPROCESSID	uniqueidentifier	INOUT	MKTSEGMENTATIONACTIVATEPROCESSID
@ARCHIVEDREMINDERSCOUNT	int	INOUT	ARCHIVEDREMINDERSCOUNT
@NAME	nvarchar(100)	INOUT
@LETTERCOUNT	int	INOUT

Definition

Copy


CREATE procedure dbo.USP_DATAFORMTEMPLATE_VIEW_REMINDERPAGEEXPRESSION
(
    @DATALOADED bit = 0 output,
    @REMINDEROPTIONID uniqueidentifier = null output,
    @MKTSEGMENTATIONACTIVATEPROCESSID uniqueidentifier = null output,
    @ARCHIVEDREMINDERSCOUNT int = null output,
    @NAME nvarchar(100) = null output,
    @LETTERCOUNT int = null output
)
as
    set nocount on;

    -- be sure to set this, in case the select returns no rows
    set @DATALOADED = 0;

    declare @ID uniqueidentifier = (select top(1) ID from dbo.REMINDEROPTION);

    select
        @DATALOADED = 1,
        @REMINDEROPTIONID = REMINDEROPTION.ID,
        @MKTSEGMENTATIONACTIVATEPROCESSID = MKTSEGMENTATIONACTIVATEPROCESS.ID,
        @ARCHIVEDREMINDERSCOUNT = (select count(ID) from dbo.PLEDGEREMINDERPROCESS),
        @NAME = MKTSEGMENTATION.NAME,
        @LETTERCOUNT = (select count(ID) from dbo.COMMUNICATIONLETTER where SEGMENTATIONID = @ID)
    from
        dbo.REMINDEROPTION
    inner join dbo.MKTSEGMENTATION on MKTSEGMENTATION.ID = REMINDEROPTION.ID
    left outer join dbo.MKTSEGMENTATIONACTIVATEPROCESS on MKTSEGMENTATIONACTIVATEPROCESS.SEGMENTATIONID = MKTSEGMENTATION.ID
    where
        REMINDEROPTION.ID = @ID;

    return 0;