USP_DATALIST_COURSEFACULTYRESOURCE
Returns faculty resources for a course.
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_COURSEFACULTYRESOURCE(@COURSEID uniqueidentifier)
as
set nocount on;
select dbo.FACULTYCOURSE.ID,
dbo.FACULTYCOURSE.FACULTYID,
dbo.CONSTITUENT.NAME
from dbo.FACULTYCOURSE
inner join dbo.FACULTY
on dbo.FACULTYCOURSE.FACULTYID = dbo.FACULTY.ID
inner join dbo.CONSTITUENT
on dbo.FACULTY.ID = dbo.CONSTITUENT.ID
where dbo.FACULTYCOURSE.COURSEID = @COURSEID
and ISRESOURCE = 1