UFN_PATTERNBLOCKMEETING_LENGTHINPERIODS_VALID
Check to see if the length is valid for the number of available periods
Return
| Return Type |
|---|
| bit |
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @TIMETABLEDAYPERIODID | uniqueidentifier | IN | |
| @LENGTHINPERIODS | int | IN |
Definition
Copy
CREATE function dbo.UFN_PATTERNBLOCKMEETING_LENGTHINPERIODS_VALID
(
@TIMETABLEDAYPERIODID uniqueidentifier,
@LENGTHINPERIODS int
)
returns BIT
as
begin
if coalesce((select
(select * from
(
select ROW_NUMBER() OVER (ORDER BY periods.STARTTIME) as 'ROW_NUMBER'
from
TIMETABLEDAYPERIOD periods
where
periods.TIMETABLEDAYID = TIMETABLEDAYPERIOD.TIMETABLEDAYID
and periods.STARTTIME >= TIMETABLEDAYPERIOD.STARTTIME
) as endrow
where
endrow.ROW_NUMBER = @LENGTHINPERIODS)
from
TIMETABLEDAYPERIOD
where
TIMETABLEDAYPERIOD.ID = @TIMETABLEDAYPERIODID),0) > 0
return 1;
return 0;
end