USP_DATALIST_EVENTINVITATIONCALENDARITEM

Displays event invitation items on the organization's calendar.

Parameters

Parameter	Parameter Type	Mode	Description
@STARTDATE	datetime	IN	Start date
@ENDDATE	datetime	IN	End date
@EVENTID	uniqueidentifier	IN	Event

Definition

Copy



CREATE procedure dbo.USP_DATALIST_EVENTINVITATIONCALENDARITEM
(
    @STARTDATE datetime = null,
    @ENDDATE datetime = null,
    @EVENTID uniqueidentifier = null
)
as
    set nocount on;

    select
        INVITATION.ID,
        INVITATION.EVENTID,
        INVITATION.NAME,
        INVITATION.MAILDATE
    from
        dbo.INVITATION
    where
        (
            ( (INVITATION.MAILDATE between @STARTDATE and @ENDDATE) or (@STARTDATE is null and @ENDDATE is null) )
            or ( (INVITATION.MAILDATE >= @STARTDATE) and (@ENDDATE is null and @STARTDATE is not null) )
            or ( (INVITATION.MAILDATE <= @ENDDATE) and (@STARTDATE is null and @ENDDATE is not null) )
        )
        and ( (INVITATION.EVENTID = @EVENTID) or (@EVENTID is null) )
    order by
        INVITATION.NAME;