UFN_COURSERESTRICTION_GETSTARTTERMS

Get the start terms for a course restriction record.

Return

Return Type
table

Parameters

Parameter	Parameter Type	Mode	Description
@COURSERESTRICTIONID	uniqueidentifier	IN

Definition

Copy



CREATE function dbo.UFN_COURSERESTRICTION_GETSTARTTERMS(
    @COURSERESTRICTIONID uniqueidentifier
)
returns table
as return
    (select 
        COURSERESTRICTIONSTARTTERM.ID, 
        COURSERESTRICTIONSTARTTERM.STARTDATE, 
        COURSERESTRICTIONSTARTTERM.ENDDATE,
        TERMNAMECODE.DESCRIPTION as NAME
    from 
        dbo.COURSERESTRICTIONSTARTTERM
    join dbo.COURSERESTRICTION on COURSERESTRICTION.ID = COURSERESTRICTIONSTARTTERM.COURSERESTRICTIONID
    join dbo.COURSE on COURSE.ID = COURSERESTRICTION.COURSEID
    join dbo.TERM on TERM.ID = dbo.UFN_TERM_GET_FORSCHOOL_BYDATE(SCHOOLID, COURSERESTRICTIONSTARTTERM.STARTDATE, COURSERESTRICTIONSTARTTERM.ENDDATE)
    join dbo.TERMNAMECODE on TERMNAMECODE.ID = TERM.TERMNAMECODEID
    where 
        COURSERESTRICTIONID = @COURSERESTRICTIONID
)