USP_DATALIST_STUDENTSKILLCOURSES

Returns a list of the courses using the specified skill.

Parameters

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

Definition

Copy



create procedure dbo.USP_DATALIST_STUDENTSKILLCOURSES
(@CONTEXTID uniqueidentifier)
as
    set nocount on;

    select COURSE.ID,
           COURSE.COURSEID,
           COURSE.NAME
    from dbo.STUDENTSKILLCOURSE
        inner join dbo.COURSE on STUDENTSKILLCOURSE.COURSEID = COURSE.ID
    where STUDENTSKILLCOURSE.STUDENTSKILLID = @CONTEXTID
    order by COURSE.COURSEID