USP_DATALIST_DAILYSALEITEMPROGRAM

This data list returns all daily sale item programs currently configured.

Parameters

Parameter	Parameter Type	Mode	Description
@INCLUDEADMISSION	bit	IN	Include admission
@INCLUDEEVENTS	bit	IN	Include events
@INCLUDEMEMBERSHIPS	bit	IN	Include memberships

Definition

Copy



            create procedure dbo.USP_DATALIST_DAILYSALEITEMPROGRAM
            (
                @INCLUDEADMISSION bit = 1,
                @INCLUDEEVENTS bit = 1,
                @INCLUDEMEMBERSHIPS bit = 1
            )

            as
                set nocount on;

                -- Daily Admission

                select 
                    DSI.ID,
                    DSI.TYPECODE,
                    DSI.TYPE,
                    replace(replace(DSI.DESCRIPTION,char(13),''),char(10),' ') DESCRIPTION,
                    P.NAME PROGRAM,
                    PTC.DESCRIPTION PRICETYPEINFO,
                    DSI.ISACTIVE
                from dbo.DAILYSALEITEM DSI
                inner join dbo.DAILYSALEITEMPROGRAM DSIP on DSI.ID = DSIP.ID
                inner join dbo.PROGRAM P on P.ID = DSIP.PROGRAMID
                inner join dbo.PRICETYPECODE PTC on PTC.ID = DSIP.PRICETYPECODEID
                where DSI.TYPECODE = 0 
                and @INCLUDEADMISSION = 1

                union all

                -- Scheduled Events

                select
                    DSI.ID,
                    DSI.TYPECODE,
                    DSI.TYPE,
                    replace(replace(DSI.DESCRIPTION,char(13),''),char(10),' ') DESCRIPTION,
                    P.NAME PROGRAM,
                    PTC.DESCRIPTION PRICETYPEINFO,
                    DSI.ISACTIVE
                from dbo.DAILYSALEITEM DSI
                inner join dbo.DAILYSALEITEMPROGRAM DSIP on DSI.ID = DSIP.ID
                inner join dbo.PROGRAM P on P.ID = DSIP.PROGRAMID
                inner join dbo.PRICETYPECODE PTC on PTC.ID = DSIP.PRICETYPECODEID
                where DSI.TYPECODE = 1
                and @INCLUDEEVENTS = 1