USP_SIMPLEDATALIST_COURSEFACULTYRESOURCE

CREATE procedure dbo.USP_SIMPLEDATALIST_COURSEFACULTYRESOURCE
(
    @COURSEID uniqueidentifier = null
)
as
    select 
        dbo.FACULTY.ID as VALUE, 
        dbo.CONSTITUENT.NAME as LABEL
    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
    order by dbo.CONSTITUENT.NAME