USP_DATALIST_EVENTBYDATE
Get all events taking place on a given date
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @EVENTWITHDATE | uniqueidentifier | IN | Input parameter indicating the context ID for the data list. |
Definition
Copy
CREATE procedure dbo.USP_DATALIST_EVENTBYDATE
(
@EVENTWITHDATE uniqueidentifier
)
as
set nocount on;
declare @DATETOCOPY datetime;
select @DATETOCOPY = STARTDATE from dbo.EVENT where ID = @EVENTWITHDATE;
select
EVENT.ID,
EVENT.NAME,
EVENT.STARTTIME as STARTTIMEHM,
EVENT.ENDTIME as ENDTIMEHM,
EVENT.STARTDATE as EVENTDATE
from
dbo.EVENT
inner join dbo.PROGRAM on EVENT.PROGRAMID = PROGRAM.ID
where
EVENT.STARTDATE = @DATETOCOPY
and PROGRAM.ISACTIVE = 1
order by
EVENT.STARTDATE,
STARTTIMEHM,
ENDTIMEHM;
return 0;