UFN_PROGRAMDAILYADMISSION_ISONSALE

Returns whether the specified daily admission program is on-sale information for a given date

Return

Return Type
bit

Parameters

Parameter	Parameter Type	Mode
@PROGRAMID	uniqueidentifier	IN
@SALEDATE	datetime	IN
@SALESMETHODTYPECODE	tinyint	IN

Definition

Copy



CREATE function dbo.UFN_PROGRAMDAILYADMISSION_ISONSALE
(
    @PROGRAMID uniqueidentifier,
    @SALEDATE datetime,
    @SALESMETHODTYPECODE tinyint
)
returns bit
with execute as caller
as begin
    if exists (
        select 1
        from dbo.PROGRAMSALESMETHOD
        inner join dbo.SALESMETHOD on SALESMETHOD.ID = PROGRAMSALESMETHOD.SALESMETHODID
        where
            SALESMETHOD.TYPECODE = @SALESMETHODTYPECODE
            and PROGRAMSALESMETHOD.PROGRAMID = @PROGRAMID
    )
        return 1;

    return 0;
end