UFN_ACADEMICYEAR_GETDATESBYSESSIONID

Returns the start and end dates of the academic year associated with a session.

Return

Return Type
table

Parameters

Parameter	Parameter Type	Mode	Description
@SESSIONID	uniqueidentifier	IN

Definition

Copy



create function dbo.UFN_ACADEMICYEAR_GETDATESBYSESSIONID(
    @SESSIONID uniqueidentifier
)
returns table
as return
    (select 
        ACADEMICYEAR.STARTDATE,
        ACADEMICYEAR.ENDDATE
    from 
        dbo.ACADEMICYEAR
            inner join dbo.SESSION on ACADEMICYEAR.ID = SESSION.ACADEMICYEARID
    where
        SESSION.ID = @SESSIONID 
)