Aeries Software

Attached are SQL Queries to evaluate either Aeries Web Security or SQL Security for your legacy Aeries Client accounts.

Parent/Student Portal Accounts Percentage and Recent Utilization --This is a nice global view of students having one or more PWA parent or student ac...

Teacher Gradebook Usage: Example SQL queries attached in text file

select cd from loc  This will return one row per record. DECLARE @something NVARCHAR(10) DECLARE @together NVARCHAR(max) = '' DECLAR...

SELECT enr.sc, enr.pr,ENR.ID, ENR.ED, ENR.LD, enr.er, enr_1.sc,enr_1.pr, ENR_1.ED AS Expr1, ENR_1.LD AS Expr2, enr_1.er FROM ENR INNER JOIN ENR A...

This will return the appropriate graduation year for the student based on the year of the database and grade of the student. SELECT id,gr,'20'...

Use this to break a single row of elements into multiple rows. DECLARE @stuff as nvarchar(1000) = '6,,7,99,3,22,4' -- String to be parsed. DE...

CREATE TABLE #RowCountsAndSizes (TableName NVARCHAR(128),rows CHAR(11), reserved VARCHAR(18),data VARCHAR(18),index_size VARCHAR(18), ...

How to determine the academic year of an Aeries database in SQL. SELECT CAST(20-FLOOR(CAST(SUBSTRING(DB_NAME(),4,2) AS INT)/80) AS VARCHAR(2)) + CAST(SU...

------use variables DECLARE @THISDAY AS DATETIME =  getdate() -- By default this selects today for the "as of" date DECLARE @StarDate AS DATETIME ...

Overview The Aeries SQL Server database definitions have for a long time included a scalar-valued function named dbo.Get_Description. Until recently, the Q...

People sometimes indicated a desire to output all PGM and/or AUT statuses that are relevant on one line. While Analytics allows a comfortable way to drill i...

This tSQL will not only create a view called PGMS (Program and Authorization Status), but it also adds itself to the CTD (Custom Table Definitions) and CTF ...