UFN_SCHEDULEDATE_GETSESSION

Returns the sessionid for a given date and school.

Return

Return Type
uniqueidentifier

Parameters

Parameter Parameter Type Mode Description
@DATE date IN
@SCHOOLID uniqueidentifier IN

Definition

Copy



                create function dbo.UFN_SCHEDULEDATE_GETSESSION
                (
                    @DATE date,
                    @SCHOOLID uniqueidentifier
                )
                returns uniqueidentifier
                as
                begin
                    declare @SESSIONID uniqueidentifier

                    select @SESSIONID = SESSION.ID
                    from SESSION 
                    inner join ACADEMICYEAR
                        on ACADEMICYEAR.ID = SESSION.ACADEMICYEARID
                    where ACADEMICYEAR.SCHOOLID = @SCHOOLID and
                        @DATE >= (select min(STARTDATE) from TERM where SESSIONID = SESSION.ID) AND
                        @DATE <= (select max(ENDDATE) from TERM where SESSIONID = SESSION.ID)

                    return @SESSIONID
                end