common student service queries

CourseSectionQuery.sql

SELECT     c.TermCode
  , c.Crn
	, c.Subject
	, c.CourseNumb
	, c.Sequence
	, c.Name
	, s.SectionType
	, s.StartDate
	, s.EndDate
	, s.StartTime
	, s.EndTime
	, s.DaysOfWeek
FROM         
	vCourses c 
	INNER JOIN Sections s
        ON c.TermCode = s.TermCode 
            AND c.Crn = s.Crn
WHERE 
	c.TermCode = '201303'
	AND c.DepartmentId = 'MAT'

CoursesSubjectQuery.sql

SELECT     c.TermCode
  , c.Crn
	, c.Subject
	, c.CourseNumb
	, c.Sequence
	, c.Name
	, s.SectionType
	, s.StartDate
	, s.EndDate
	, s.StartTime
	, s.EndTime
	, s.DaysOfWeek
FROM         
	vCourses c 
	INNER JOIN Sections s
        ON c.TermCode = s.TermCode 
            AND c.Crn = s.Crn
WHERE 
	c.TermCode = @Term
	AND c.Subject = @Subject
	AND c.CourseNumb in ({0})

RostersSubjectQuery.sql

select s.LoginId
,s.FirstName
,s.LastName
,s.Email
,r.Crn
from CourseRoster r
  inner join vCourses c on (r.Crn = c.Crn AND r.TermCode = c.TermCode)
	inner join students s on r.LoginId = s.LoginId
where 
	r.TermCode = @Term	
	AND c.Subject = @Subject
	AND c.CourseNumb in ({0})

select i.LoginId
,i.FirstName
,i.LastName
,i.Email
,c.Crn
from CourseInstructors ci
	inner join vCourses c on (ci.Crn = c.Crn AND ci.TermCode = c.TermCode)
	inner join Instructors i on ci.LoginId = i.LoginId
where
	ci.TermCode = @Term
	AND c.Subject = @Subject
	AND c.CourseNumb in ({0})

-- Regarding CoursesSubjectQuery.sql

/*
Missing Index Details from SQLQuery31.sql - clamps.StudentService (AESDEAN\taylor (51))
The Query Processor estimates that implementing the following index could improve the query cost by 54.7953%.
*/

/*
USE [StudentService]
GO
CREATE NONCLUSTERED INDEX [Sections_TermCode_CVIDX])
ON [dbo].[Sections] ([TermCode])
INCLUDE ([Crn],[SectionType],[StartDate],[EndDate],[StartTime],[EndTime],[DaysOfWeek])
GO
*/