UFN_ONLINEPROGRAMEVENTONSALE_BYPROGRAM

Return

Return Type
table

Parameters

Parameter	Parameter Type	Mode
@PROGRAMID	uniqueidentifier	IN
@STARTDATETIME	datetime	IN
@ENDDATETIME	datetime	IN
@INCLUDESOLDOUT	bit	IN
@NAME	nvarchar(150)	IN
@EXCLUDEDATE	date	IN
@LIMITROWS	int	IN
@MAXROWS	int	IN

Definition

Copy



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

    )

    return
end