USP_COURSERESTRICTION_TERM_COMPARE
Compare Start terms of Course restrictions.
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @FROM_SESSIONID | uniqueidentifier | IN | |
| @TO_SESSIONID | uniqueidentifier | IN | |
| @COURSEID | uniqueidentifier | IN | |
| @FROM_TERMNAMECODEID | uniqueidentifier | IN | |
| @COURSERESTRICTION_TERM_MATCH | bit | INOUT |
Definition
Copy
CREATE PROC USP_COURSERESTRICTION_TERM_COMPARE
(
@FROM_SESSIONID uniqueidentifier,
@TO_SESSIONID uniqueidentifier,
@COURSEID uniqueidentifier,
@FROM_TERMNAMECODEID uniqueidentifier,
@COURSERESTRICTION_TERM_MATCH bit = 0 output
)
as
begin
set @COURSERESTRICTION_TERM_MATCH = 0
if exists
(
select TM.TERMNAMECODEID T_NAMEID
from COURSE CR
inner join COURSERESTRICTION CRC
on CRC.COURSEID = CR.ID
inner join COURSERESTRICTIONSTARTTERM CRCST
on CRCST.COURSERESTRICTIONID = CRC.ID
inner join TERM TM
on TM.STARTDATE = CRCST.STARTDATE
and TM.ENDDATE = CRCST.ENDDATE
where TM.SESSIONID = @FROM_SESSIONID
and CR.ID = @COURSEID
and TM.TERMNAMECODEID = @FROM_TERMNAMECODEID
and TM.TERMNAMECODEID in
(
select TM.TERMNAMECODEID T_NAMEID
from COURSE CR
inner join COURSERESTRICTION CRC
on CRC.COURSEID = CR.ID
inner join COURSERESTRICTIONSTARTTERM CRCST
on CRCST.COURSERESTRICTIONID = CRC.ID
inner join TERM TM
on TM.STARTDATE = CRCST.STARTDATE
and TM.ENDDATE = CRCST.ENDDATE
where TM.SESSIONID = @TO_SESSIONID
and CR.ID = @COURSEID
)
)
set @COURSERESTRICTION_TERM_MATCH = 1
end