USP_ACADEMICYEAR_SETUPNEXT_SESSIONLIST

CREATE procedure USP_ACADEMICYEAR_SETUPNEXT_SESSIONLIST
(
    @ACADEMICYEARID uniqueidentifier
)
        as

        begin
            set nocount on

        select
            SESSIONNAME,
            TERMNAME,
            DATEADD(YEAR,1,START_DATE) STARTDATE,
            DATEADD(YEAR,1,END_DATE) ENDDATE,
            DATEADD(YEAR,1,WDATE) WITHDRAWALDATE,
            TIMETABLEID,
            TIMETABLEDAYID
          from
            (select
            AY.ID ACADEMICYEARID,
            SS.SESSIONNAMECODEID SESSIONNAME,
            TM.TERMNAMECODEID TERMNAME,
            TM.STARTDATE START_DATE,
            TM.ENDDATE END_DATE,
            TM.WITHDRAWALDATE WDATE,
            SS.TIMETABLEID,
            TM.TIMETABLEDAYID
            from ACADEMICYEAR AY
            INNER JOIN SESSION SS ON SS.ACADEMICYEARID = AY.ID
            INNER JOIN TERM TM ON TM.SESSIONID = SS.ID) A
          where A.ACADEMICYEARID = @ACADEMICYEARID

        end