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