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