USP_SIMPLEDATALIST_PROGRAMEVENT_TIMESAVAILABLEONDATE

Lists available program event times for a specific date.

Parameters

Parameter	Parameter Type	Mode	Description
@PROGRAMID	uniqueidentifier	IN	PROGRAMID
@DATE	datetime	IN	DATE
@EVENTDATE	date	IN	EVENTDATE
@SALESMETHODTYPECODE	tinyint	IN	Sales method type

Definition

Copy



                CREATE procedure dbo.USP_SIMPLEDATALIST_PROGRAMEVENT_TIMESAVAILABLEONDATE
                (
                    @PROGRAMID uniqueidentifier = null,
                    @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] as [VALUE],
                        dbo.UFN_HOURMINUTE_DISPLAYTIME([EVENT].[STARTTIME]) as [LABEL]
                    from  dbo.UFN_PROGRAMEVENT_AVAILABILITYONDATE(@PROGRAMID, @DATE, @EVENTDATE, @SALESMETHODID, 1,1,0, 1000, null) as [EVENT]
                    order by [EVENT].[STARTTIME]