UFN_COURSE_GETDEPARTMENTS

Returns the departments for a course.

Return

Return Type
table

Parameters

Parameter	Parameter Type	Mode	Description
@COURSEID	uniqueidentifier	IN

Definition

Copy



create function dbo.UFN_COURSE_GETDEPARTMENTS(@COURSEID uniqueidentifier)
returns table
as return
(
    select 
        COURSEACADEMICCATALOGDEPARTMENT.ID,
        ACADEMICCATALOGDEPARTMENTID,
        ACADEMICCATALOGDEPARTMENT.USERID
    from 
        dbo.COURSEACADEMICCATALOGDEPARTMENT
    inner join dbo.ACADEMICCATALOGDEPARTMENT   on COURSEACADEMICCATALOGDEPARTMENT.ACADEMICCATALOGDEPARTMENTID = ACADEMICCATALOGDEPARTMENT.ID
    where 
        COURSEACADEMICCATALOGDEPARTMENT.COURSEID = @COURSEID
)