USP_DATALIST_ONLINESCHEDULEDPROGRAM

CREATE procedure dbo.USP_DATALIST_ONLINESCHEDULEDPROGRAM
(
    @STARTDATE datetime = null,
    @ENDDATE datetime = null,
    @PROGRAMCATEGORYCODEID uniqueidentifier = null,
    @INCLUDEPREREGISTERED bit = 0,
    @EXCLUDEOFFSALE bit = 0 --maintaining old behavior

)
as
    set nocount on;

    select 
        ID,
        NAME,
        PUBLICDESCRIPTIONHTML,
        ISPREREGISTERED
    from dbo.PROGRAM
    cross apply (
        select ID as EVENTID
        from dbo.UFN_ONLINEPROGRAMEVENTONSALE_BYPROGRAM_2 (
            PROGRAM.ID,
            @STARTDATE,
            @ENDDATE,
            1, --@INCLUDESOLDOUT

            null, --@NAME

            null, --@EXCLUDEDATE

            1, -- Limit Rows

            1, -- Max Rows

            @EXCLUDEOFFSALE
        )
        where 
            PROGRAM.ISDAILYADMISSION = 0 and
            PROGRAM.ISACTIVE = 1 and 
            ((@PROGRAMCATEGORYCODEID is null) or (PROGRAMCATEGORYCODEID = @PROGRAMCATEGORYCODEID)) and
            ((ISPREREGISTERED = 0) or (ISPREREGISTERED = @INCLUDEPREREGISTERED))
    ) as PROGRAMEVENTS