UFN_ONLINEPROGRAMEVENTONSALE_BYPROGRAM_2

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
@EXCLUDEOFFSALE	bit	IN

Definition

Copy



CREATE function dbo.UFN_ONLINEPROGRAMEVENTONSALE_BYPROGRAM_2(
    @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,
    @EXCLUDEOFFSALE bit = 0
)
returns table
as return
    select 
        [EVENT].[ID], 
        [EVENT].[NAME],
        [TICKETCOUNT].[AVAILABILITY],
        [EVENT].[STARTDATE],
        [EVENT].[STARTTIME], 
        [EVENT].[ENDTIME],
        [EVENT].[URL]
    from dbo.UFN_ONLINEPROGRAMEVENTONSALE_BYPROGRAM_CORE_2 (
        @PROGRAMID,
        @STARTDATETIME,
        @ENDDATETIME,
        @NAME,
        @EXCLUDEDATE,
        @LIMITROWS,
        @MAXROWS,
        @EXCLUDEOFFSALE
    ) [EVENT]
    inner join dbo.V_PROGRAMEVENT_TICKETCOUNTS [TICKETCOUNT] on
        [EVENT].[ID] = [TICKETCOUNT].[ID]
    where
        ((@INCLUDESOLDOUT = 1) or [TICKETCOUNT].[AVAILABILITY] > 0)