This folder contains 17 articles
SQL Scripts
CREATE TABLE #RowCountsAndSizes (TableName NVARCHAR(128),rows CHAR(11),
reserved VARCHAR(18),data VARCHAR(18),index_size VARCHAR(18),
...
Thu, Feb 9, 2017 at 10:40 AM
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...
Tue, Mar 21, 2017 at 11:07 AM
------use variables
DECLARE @THISDAY AS DATETIME = getdate() -- By default this selects today for the "as of" date
DECLARE @StarDate AS DATETIME ...
Wed, Aug 22, 2018 at 8:49 AM
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...
Mon, Jun 15, 2020 at 12:30 PM
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...
Wed, Dec 5, 2018 at 7:42 AM
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 ...
Mon, Sep 10, 2018 at 11:10 AM
DECLARE @DBName NVARCHAR(255)
DECLARE @SQL NVARCHAR(MAX)
DECLARE @DBUSER NVARCHAR(20) = 'AeriesNetUser'
DECLARE db_cursor CURSOR FOR
SELECT name
F...
Wed, Jul 24, 2024 at 6:34 PM