UFN_ONLINEPROGRAMEVENTONSALE_BYPROGRAM_CORE

--This function was added to a client database after the 2.96 release. 

--If working on this function during the 2.97 dev cycle, consider this as released and maintain backward compatibility (please).

CREATE function dbo.UFN_ONLINEPROGRAMEVENTONSALE_BYPROGRAM_CORE(
    @PROGRAMID uniqueidentifier = null,
    @STARTDATETIME datetime = null,
    @ENDDATETIME datetime = null,
    @NAME nvarchar(150) = null,
    @EXCLUDEDATE date = null,
    @LIMITROWS int = 0,
    @MAXROWS int = 0
)
returns @result table (
    [ID] uniqueidentifier,
    [NAME] nvarchar(100),
    [STARTDATE] date,
    [STARTTIME] dbo.UDT_HOURMINUTE,
    [ENDTIME] dbo.UDT_HOURMINUTE,
    [URL] nvarchar(1024)
)
with execute as caller
as begin
    insert into @result
    select 
        [EVENT].[ID], 
        [EVENT].[NAME],
        [EVENT].[STARTDATE],
        [EVENT].[STARTTIME], 
        [EVENT].[ENDTIME],
        [EVENT].[URL]
    from dbo.UFN_ONLINEPROGRAMEVENTONSALE_BYPROGRAM_CORE_2 (
        @PROGRAMID,
        @STARTDATETIME,
        @ENDDATETIME,
        @NAME,
        @EXCLUDEDATE,
        @LIMITROWS,
        @MAXROWS,
        0 --@EXCLUDEOFFSALE

    ) [EVENT]

    return
end