USP_DATALIST_AVAILABLEPROGRAMEVENTONDATE

Lists available program events on a specific date.

Parameters

Parameter	Parameter Type	Mode	Description
@PROGRAMID	uniqueidentifier	IN	Input parameter indicating the context ID for the data list.
@DATE	datetime	IN	Sale date
@EVENTDATE	date	IN	Event date
@SALESMETHODTYPECODE	tinyint	IN	Sales method type

Definition

Copy



                CREATE procedure dbo.USP_DATALIST_AVAILABLEPROGRAMEVENTONDATE
                (
                    @PROGRAMID uniqueidentifier,
                    @DATE datetime,
                    @EVENTDATE date,
                    @SALESMETHODTYPECODE tinyint = 0
                )
                as 
                    set nocount on;

                        declare @SALESMETHODID uniqueidentifier = null;
                        select @SALESMETHODID = [ID]
                        from dbo.[SALESMETHOD]
                        where [TYPECODE] = @SALESMETHODTYPECODE;

                        select 
                            [EVENT].[EVENTID], 
                            [EVENT].[AVAILABILITY],
                            [EVENT].[ENDDATE],
                            [EVENT].[ENDTIME]
                    from  dbo.UFN_PROGRAMEVENT_AVAILABILITYONDATE(@PROGRAMID, @DATE, @EVENTDATE, @SALESMETHODID,1,1,0,1000,null) as [EVENT]

                return 0;