USP_DATALIST_MAILINGCALENDARITEM

Displays mailing items on the organization's calendar.

Parameters

Parameter	Parameter Type	Mode	Description
@STARTDATE	datetime	IN	Start date
@ENDDATE	datetime	IN	End date
@INCLUDEDMMAILINGS	bit	IN	Mailings
@INCLUDEPLANNEDMAILINGS	bit	IN	Planned mailings
@ACTIVESTATUS	bit	IN	Status

Definition

Copy



CREATE procedure dbo.USP_DATALIST_MAILINGCALENDARITEM
(
    @STARTDATE datetime = null,
    @ENDDATE datetime = null,
    @INCLUDEDMMAILINGS bit = 1,
    @INCLUDEPLANNEDMAILINGS bit = 1,
    @ACTIVESTATUS bit = null
)
as
    set nocount on;

    select
        MKTSEGMENTATION.ID,
        MKTSEGMENTATION.NAME,
        MKTSEGMENTATION.MAILDATE,
        1 [TYPECODE],
        MKTSEGMENTATION.DESCRIPTION
    from
        dbo.MKTSEGMENTATION
    where
        (
            ( (MKTSEGMENTATION.MAILDATE between @STARTDATE and @ENDDATE) or (@STARTDATE is null and @ENDDATE is null) )
            or ( (MKTSEGMENTATION.MAILDATE >= @STARTDATE) and (@ENDDATE is null and @STARTDATE is not null) )
            or ( (MKTSEGMENTATION.MAILDATE <= @ENDDATE) and (@STARTDATE is null and @ENDDATE is not null) )
        )
        and (MKTSEGMENTATION.ID not in (select ID from dbo.APPEALMAILING))
        and ( (MKTSEGMENTATION.ACTIVE = @ACTIVESTATUS) or (@ACTIVESTATUS is null) )