USP_DATALIST_CALENDARITEM

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

    select
        CALENDARITEM.ID,
        CALENDARITEM.NAME,
        CALENDARITEM.STARTDATE,
        CALENDARITEM.ENDDATE,
        CALENDARITEM.DATEADDED,
        CHANGEAGENT.USERNAME as ADDEDBY
    from
        dbo.CALENDARITEM
        inner join dbo.CHANGEAGENT on CALENDARITEM.ADDEDBYID = CHANGEAGENT.ID
    where
        (
            ( (CALENDARITEM.STARTDATE between @STARTDATE and @ENDDATE) or (@STARTDATE is null and @ENDDATE is null) )
            or ( (CALENDARITEM.STARTDATE >= @STARTDATE) and (@ENDDATE is null and @STARTDATE is not null) )
            or ( (CALENDARITEM.ENDDATE <= @ENDDATE) and (@STARTDATE is null and @ENDDATE is not null) )
      or ( (CALENDARITEM.STARTDATE <= @STARTDATE) and (CALENDARITEM.ENDDATE >= @STARTDATE))
      )