This folder contains 17 articles

SQL Scripts

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

Fri, Jun 16, 2017 at 8:39 AM

1. SQL Query - sub queries
PWA examples --list account ids that have more that 3 students associated with it select aid, count(*) from pws where del = 0 group by aid having ...

Tue, Apr 18, 2017 at 4:49 PM

Parent/Student Portal Accounts Percentage and Recent Utilization
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...

Thu, Jun 29, 2017 at 2:16 PM

Aeries Query Expansion through SQL views and Custom Tables
Aeries Query is quite empowering, yet you may wish to arrive at some results that could take many steps after running Aeries Queries. Some of those steps...

Tue, Sep 27, 2022 at 4:57 PM

Dealing with the SQ (sequence) field
Some examples on how to generate the SQ field when inserting records. -- examples on how to generate the sequesnce field (SQ) -- wrong way #1 select pi...

Thu, Feb 9, 2017 at 8:45 AM

Teacher Gradebook Usage
Teacher Gradebook Usage: Example SQL queries attached in text file

Wed, May 10, 2017 at 4:15 PM

Combining multiple rows into one row or variable
select cd from loc  This will return one row per record. DECLARE @something NVARCHAR(10) DECLARE @together NVARCHAR(max) = '' DECLARE ...

Thu, Feb 9, 2017 at 9:23 AM

Finding overlapping ENR records using SQL
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...

Thu, Feb 9, 2017 at 9:45 AM

Determining a student's graduation year using SQL
This will return the appropriate graduation year (as in class of 2019) for the student based on the year of the database and grade of the student. SELEC...

Tue, May 28, 2019 at 4:48 PM

Parsing a single row into multiple rows
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. DECL...

Thu, Feb 9, 2017 at 10:33 AM