USP_DATALIST_COURSEACADEMICCATALOGDEPARTMENT_BYCOURSE

Returns a list of departments the course is in.

Parameters

Parameter	Parameter Type	Mode	Description
@COURSEID	uniqueidentifier	IN	Input parameter indicating the context ID for the data list.

Definition

Copy



CREATE procedure dbo.USP_DATALIST_COURSEACADEMICCATALOGDEPARTMENT_BYCOURSE(@COURSEID uniqueidentifier)
as
    set nocount on;

    if (select SELECTEDDEPARTMENTSCODE from dbo.COURSE where COURSE.ID = @COURSEID) = 0
        select null, '<All departments>', ''  
    else
        if (select SELECTEDDEPARTMENTSCODE from dbo.COURSE where COURSE.ID = @COURSEID) = 2
            select null, '<No departments>', ''
        else
            select ACADEMICCATALOGDEPARTMENT.ID,
                   ACADEMICCATALOGDEPARTMENT.USERID,
                   ACADEMICCATALOGDEPARTMENT.NAME
            from dbo.COURSEACADEMICCATALOGDEPARTMENT
            join dbo.ACADEMICCATALOGDEPARTMENT on ACADEMICCATALOGDEPARTMENT.ID = COURSEACADEMICCATALOGDEPARTMENT.ACADEMICCATALOGDEPARTMENTID
            where 
                COURSEACADEMICCATALOGDEPARTMENT.COURSEID = @COURSEID
            order by 
                ACADEMICCATALOGDEPARTMENT.USERID