USP_SIMPLEDATALIST_SESSION_CYCLEDAY

Returns the list of cycle days used by the session.

Parameters

Parameter	Parameter Type	Mode	Description
@SESSIONID	uniqueidentifier	IN	SESSIONID

Definition

Copy



CREATE procedure dbo.USP_SIMPLEDATALIST_SESSION_CYCLEDAY
(
    @SESSIONID uniqueidentifier = null
)
as
    set nocount on;

    select
        CYCLEDAY.ID as VALUE,
        CYCLEDAY.DESCRIPTION as LABEL
    from dbo.SESSION
        inner join dbo.TIMETABLE on SESSION.TIMETABLEID = TIMETABLE.ID
        inner join dbo.CYCLEDAY on TIMETABLE.CYCLEID = CYCLEDAY.CYCLEID
    where @SESSIONID = SESSION.ID
    order by CYCLEDAY.SEQUENCE asc