USP_DATALIST_PREREGISTEREDPROGRAMEVENT

Returns a list of preregistered program events.
Parameters

Parameter	Parameter Type	Mode	Description
@STARTDATE	date	IN	Start date
@ENDDATE	date	IN	End date
Definition

Copy


                CREATE procedure dbo.USP_DATALIST_PREREGISTEREDPROGRAMEVENT
                (
                    @STARTDATE date = null,
                    @ENDDATE date = null
                )
                as
                    set nocount on;

                    declare @STARTDATEWITHOFFSET datetimeoffset;
                    declare @ENDDATEWITHOFFSET datetimeoffset;

                    if @STARTDATE is null
                        set @STARTDATEWITHOFFSET = dbo.UFN_TIMEZONEENTRY_GETSYSTEMDEFAULTDATEWITHTIMEOFFSET(dbo.UFN_DATE_GETEARLIESTTIME(getdate()), 0);
                    else
                        set @STARTDATEWITHOFFSET = dbo.UFN_TIMEZONEENTRY_GETSYSTEMDEFAULTDATEWITHTIMEOFFSET(dbo.UFN_DATE_GETEARLIESTTIME(@STARTDATE), 0);

                    if @ENDDATE is null
                        set @ENDDATEWITHOFFSET = dbo.UFN_TIMEZONEENTRY_GETSYSTEMDEFAULTDATEWITHTIMEOFFSET(dbo.UFN_DATE_GETLATESTTIME(@STARTDATEWITHOFFSET), 0);
                    else
                        set @ENDDATEWITHOFFSET = dbo.UFN_TIMEZONEENTRY_GETSYSTEMDEFAULTDATEWITHTIMEOFFSET(dbo.UFN_DATE_GETLATESTTIME(@ENDDATE), 0);

                    select EVENT.ID,
                        EVENT.NAME,
                        EVENT.STARTDATETIME,
                        EVENT.STARTTIME
                    from dbo.EVENT
                    inner join dbo.PROGRAM
                        on PROGRAM.ID = EVENT.PROGRAMID
                    where (EVENT.STARTDATETIMEWITHOFFSET between @STARTDATEWITHOFFSET and @ENDDATEWITHOFFSET)
                        and (PROGRAM.ISPREREGISTERED = 1)
                        and (PROGRAM.ISACTIVE = 1)
                    order by EVENT.STARTTIME asc, EVENT.NAME asc