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