USP_DATALIST_GETNEXTYEARBYSCHOOL

Gives the user the next academic year by school.

Parameters

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

Definition

Copy



                CREATE procedure dbo.USP_DATALIST_GETNEXTYEARBYSCHOOL
                    (
                    @SCHOOLID uniqueidentifier = null                    
                    )
                    as                    
                    set nocount on

                    declare @CURRENTDATE datetime
                    set @CURRENTDATE = getDate()

                    select SCHOOLID,
                            ACADEMICYEARNAMECODE.DESCRIPTION AS NAME,
                            ACADEMICYEAR.ID,
                            BILLINGSTARTDATE,
                            BILLINGENDDATE
                        from dbo.ACADEMICYEAR        
                        inner join dbo.ACADEMICYEARNAMECODE 
                            on ACADEMICYEAR.ACADEMICYEARNAMECODEID = ACADEMICYEARNAMECODE.ID                
                        where STARTDATE>@CURRENTDATE AND SCHOOLID=@SCHOOLID
                        order by STARTDATE asc