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