UFN_PROGRAMSALESMETHOD_GETDAILYADMISSIONONSALEINFO

Returns on-sale information for a daily admission program.

Return

Return Type
table

Parameters

Parameter	Parameter Type	Mode	Description
@PROGRAMID	uniqueidentifier	IN

Definition

Copy



            CREATE function dbo.UFN_PROGRAMSALESMETHOD_GETDAILYADMISSIONONSALEINFO
            (
                @PROGRAMID uniqueidentifier
            ) returns table
            as
                return
                select
                    PROGRAMSALESMETHOD.ID,
                    PROGRAMSALESMETHOD.SALESMETHODID,
                    SALESMETHOD.SEQUENCE
                from dbo.PROGRAMSALESMETHOD
                inner join dbo.SALESMETHOD on PROGRAMSALESMETHOD.SALESMETHODID = SALESMETHOD.ID
                where PROGRAMID = @PROGRAMID