USP_SIMPLEDATALIST_ADDREQUESTSFORMULTIPLESTUDENTSSESSIONNAMECODE

Returns a list of Session table entries for a given academic year if specified.

Parameters

Parameter	Parameter Type	Mode	Description
@ACADEMICYEARID	uniqueidentifier	IN	Academic Year

Definition

Copy



CREATE procedure dbo.USP_SIMPLEDATALIST_ADDREQUESTSFORMULTIPLESTUDENTSSESSIONNAMECODE
(
    @ACADEMICYEARID uniqueidentifier = null
) as

    if @ACADEMICYEARID in ('00000000-0000-0000-0000-000000000000', '00000000-0000-0000-0000-000000000001', '00000000-0000-0000-0000-000000000002')
        set @ACADEMICYEARID = null

    select distinct
        SESSIONNAMECODE.ID as VALUE, 
        SESSIONNAMECODE.DESCRIPTION as LABEL
    from dbo.ACADEMICYEAR
        inner join dbo.SESSION on ACADEMICYEAR.ID = SESSION.ACADEMICYEARID
        inner join dbo.SESSIONNAMECODE on SESSION.SESSIONNAMECODEID = SESSIONNAMECODE.ID
    where (
        @ACADEMICYEARID is null or
        ACADEMICYEAR.ID = @ACADEMICYEARID
    )
    order by DESCRIPTION