UFN_SESSION_GETTERMS

Get terms for a session

Return

Return Type
table

Parameters

Parameter	Parameter Type	Mode	Description
@SESSIONID	uniqueidentifier	IN

Definition

Copy



CREATE function dbo.UFN_SESSION_GETTERMS
(
  @SESSIONID uniqueidentifier
)
returns table
as return 
  (select TERM.ID, 
          STARTDATE, 
          ENDDATE, 
          TERMNAMECODEID,
          TIMETABLEDAYID,
          DESCRIPTION,
          WITHDRAWALDATE
    from dbo.TERM
    join dbo.TERMNAMECODE on TERMNAMECODE.ID = TERM.TERMNAMECODEID
    where SESSIONID = @SESSIONID)