USP_SIMPLEDATALIST_TIMETABLE
Simple list of timetables.
Parameters
Parameter | Parameter Type | Mode | Description |
---|---|---|---|
@INCLUDEINACTIVE | bit | IN |
Definition
Copy
CREATE procedure dbo.USP_SIMPLEDATALIST_TIMETABLE
(
@INCLUDEINACTIVE bit = 0
)
as
select
ID as VALUE,
NAME as LABEL
from dbo.TIMETABLE
where
(
(@INCLUDEINACTIVE = 1)
or
(ISACTIVE = 1)
)
order by NAME