USP_SIMPLEDATALIST_TIMETABLEDAYPERIOD
Simple list of timetable day periods.
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @TIMETABLEDAYID | uniqueidentifier | IN |
Definition
Copy
CREATE procedure dbo.USP_SIMPLEDATALIST_TIMETABLEDAYPERIOD
(
@TIMETABLEDAYID uniqueidentifier
)
as
select
TIMETABLEDAYPERIOD.ID as VALUE,
TIMETABLEDAYPERIOD.PERIOD as LABEL
from dbo.TIMETABLEDAYPERIOD
inner join TIMETABLEDAY
on TIMETABLEDAY.ID = TIMETABLEDAYPERIOD.TIMETABLEDAYID
where TIMETABLEDAY.ID = @TIMETABLEDAYID
order by STARTTIME