UFN_SESSION_GET_FORSCHOOL_BYDATE
Returns the ID of the session for a school starting and ending on or within the given dates.
Return
| Return Type |
|---|
| uniqueidentifier |
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @SCHOOLID | uniqueidentifier | IN | |
| @STARTDATE | date | IN | |
| @ENDDATE | date | IN |
Definition
Copy
CREATE function dbo.UFN_SESSION_GET_FORSCHOOL_BYDATE(
@SCHOOLID uniqueidentifier,
@STARTDATE date,
@ENDDATE date
)
returns uniqueidentifier
with execute as caller
as begin
return (
select
SESSION.ID
from
dbo.ACADEMICYEAR
join
dbo.SESSION on SESSION.ACADEMICYEARID = ACADEMICYEAR.ID
join
dbo.TERM on TERM.SESSIONID = SESSION.ID
where
ACADEMICYEAR.SCHOOLID = @SCHOOLID
group by
SESSION.ID
having
MIN(TERM.STARTDATE) <= @STARTDATE
and MAX(TERM.ENDDATE) >= @ENDDATE
)
end