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));
}
}