USP_DATALIST_MAILINGCALENDARITEM_2

CREATE procedure dbo.USP_DATALIST_MAILINGCALENDARITEM_2
(
    @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 as STARTDATE,
        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) )
        and (MKTSEGMENTATION.COMMUNICATIONTYPECODE <> 2) --Type code 2 is event invitations, which show up on the event datalist