USP_SIMPLEDATALIST_TIMETABLEDAY
Simple list of timetable days.
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @TIMETABLEID | uniqueidentifier | IN |
Definition
Copy
CREATE procedure dbo.USP_SIMPLEDATALIST_TIMETABLEDAY
(
@TIMETABLEID uniqueidentifier
)
as
select
TIMETABLEDAY.ID as VALUE,
CYCLEDAY.DESCRIPTION as LABEL
from
dbo.TIMETABLEDAY
inner join CYCLEDAY
on TIMETABLEDAY.CYCLEDAYID = CYCLEDAY.ID
where TIMETABLEDAY.TIMETABLEID = @TIMETABLEID
order by SEQUENCE