USP_DATALIST_SESSION

All of the sessions in a given academic year.

Parameters

Parameter	Parameter Type	Mode	Description
@ACADEMICYEARID	uniqueidentifier	IN	Input parameter indicating the context ID for the data list.

Definition

Copy



                CREATE procedure dbo.USP_DATALIST_SESSION
                    (
                        @ACADEMICYEARID uniqueidentifier
                    )
                as
                    set nocount on;

                    select SESSION.ID,
                           SESSIONNAMECODE.DESCRIPTION AS NAME,
                           (select min(STARTDATE) from dbo.TERM where TERM.SESSIONID = SESSION.ID ) as STARTDATE,
                           (select max(ENDDATE) from dbo.TERM where TERM.SESSIONID = SESSION.ID ) as ENDDATE,
                           (select stuff((select '; ' + TERMNAMECODE.DESCRIPTION
                               from dbo.TERM
                                    inner join dbo.TERMNAMECODE on TERM.TERMNAMECODEID = TERMNAMECODE.ID
                               where TERM.SESSIONID = SESSION.ID
                               order by TERM.STARTDATE
                               for xml path(''), type).value('.', 'nvarchar(max)'), 1, 2, '')) AS TERMS
                    from dbo.SESSION 
                    inner join dbo.SESSIONNAMECODE on SESSION.SESSIONNAMECODEID = SESSIONNAMECODE.ID
                    where (ACADEMICYEARID = @ACADEMICYEARID)
                    order by STARTDATE