USP_SIMPLEDATALIST_ENTERREQUESTSBYSTUDENT_SESSIONTERM

            CREATE procedure dbo.USP_SIMPLEDATALIST_ENTERREQUESTSBYSTUDENT_SESSIONTERM
            (
                @CURRENTAPPUSERID uniqueidentifier,
                @COURSEID uniqueidentifier
            )
            as
                declare @SESSION_STARTDATE date
                declare @SESSION_ENDDATE date

                select
                    @SESSION_STARTDATE = min(STARTDATE),
                    @SESSION_ENDDATE = max(ENDDATE)
                from dbo.TERM
                    inner join dbo.APPUSERSESSION on TERM.SESSIONID = APPUSERSESSION.SESSIONID
                where APPUSERSESSION.ID = @CURRENTAPPUSERID
                group by APPUSERSESSION.ID            

                select 
                    TERM.ID as VALUE, 
                    TERMNAMECODE.DESCRIPTION as LABEL
                from dbo.TERM
                    inner join dbo.TERMNAMECODE on TERM.TERMNAMECODEID = TERMNAMECODE.ID
                    inner join dbo.SESSION on TERM.SESSIONID = SESSION.ID
                    inner join dbo.ACADEMICYEAR on SESSION.ACADEMICYEARID = ACADEMICYEAR.ID
                    inner join dbo.COURSE on ACADEMICYEAR.SCHOOLID = COURSE.SCHOOLID
                    inner join dbo.V_COURSERESTRICTION as COURSERESTRICTION on COURSE.ID = COURSERESTRICTION.COURSEID
                    inner join dbo.COURSERESTRICTIONSTARTTERM on
                        COURSERESTRICTION.ID = COURSERESTRICTIONSTARTTERM.COURSERESTRICTIONID and
                        TERM.STARTDATE = COURSERESTRICTIONSTARTTERM.STARTDATE and
                        TERM.ENDDATE = COURSERESTRICTIONSTARTTERM.ENDDATE
                where COURSE.ID = @COURSEID
                    and TERM.STARTDATE >= @SESSION_STARTDATE
                    and TERM.ENDDATE <= @SESSION_ENDDATE
                order by TERM.STARTDATE