UFN_CORECURRICULUM_GETCOURSES

Returns the courses included in a particular core curriculum.

Return

Return Type
table

Parameters

Parameter Parameter Type Mode Description
@CORECURRICULUMID uniqueidentifier IN

Definition

Copy


create function dbo.UFN_CORECURRICULUM_GETCOURSES
(
    @CORECURRICULUMID uniqueidentifier
)
returns table
as return 
    (select ID,
                    COURSEID
     from dbo.CORECURRICULUMCOURSE
     where CORECURRICULUMID = @CORECURRICULUMID)