Preview:
static void sqlq(Args _args)
{
    str sql, StoreID;
    Connection conn;
    SqlStatementExecutePermission permission;
    Statement statement;
    ResultSet resultSet;
    int64 Qty;
    conn = new Connection();
    
    sql = "SELECT dbo.INVENTDIM.INVENTLOCATIONID AS StoreID, SUM(- (1 * dbo.INVENTTRANS.QTY)) AS Qty FROM  dbo.INVENTTRANSORIGIN INNER JOIN dbo.INVENTTRANS ON dbo.INVENTTRANSORIGIN.RECID = dbo.INVENTTRANS.INVENTTRANSORIGIN AND dbo.INVENTTRANSORIGIN.ITEMID = dbo.INVENTTRANS.ITEMID INNER JOIN dbo.INVENTDIM ON dbo.INVENTTRANS.INVENTDIMID = dbo.INVENTDIM.INVENTDIMID WHERE        (dbo.INVENTTRANSORIGIN.REFERENCECATEGORY = 0) AND (dbo.INVENTTRANS.DATEFINANCIAL BETWEEN CONVERT(DATETIME, '2019-05-01 00:00:00', 102) AND CONVERT(DATETIME, '2019-05-10 00:00:00', 102)) GROUP BY dbo.INVENTDIM.INVENTLOCATIONID";
    
    permission = new SqlStatementExecutePermission(sql);
    
    permission.assert();
    
    statement = conn.createStatement();
    resultSet = statement.executeQuery(sql);
    
    while (resultSet.next())
    {
        StoreID = resultSet.getString(1);
        Qty = resultSet.getInt64(2);
        
        info(strFmt("StoreID %1, Qty %2", StoreID, Qty));
        
    }
}
downloadDownload PNG downloadDownload JPEG downloadDownload SVG

Tip: You can change the style, width & colours of the snippet with the inspect tool before clicking Download!

Click to optimize width for Twitter