SELECT
    C.CODE AS "Табельный",
    C.NAME AS "Ф.И.О.",
    T.TRANZDATE AS "Дата",
    max(T.TRANZTIME) AS "Время",
    T.INFOSTR AS "Карта",
    sum(T.SUMM) AS "Сумма"
FROM
    DOCUMENT D
        LEFT JOIN TRANZT T ON D.ID = T.DOCUMENTID
        JOIN CLIENT C ON T.INFO2 = C.CODE
WHERE
      T.TRANZDATE = cast('now' as date) and
      D.STATE = 1 AND
      D.ISFISCAL = 1 AND
      T.TRANZTYPE = '36' and
      T.INFO = '8'
GROUP BY
    C.CODE,
    C.NAME,
    T.TRANZDATE,
    T.INFOSTR

set isql="C:\Program Files (x86)\FireBird\FireBird_2_1\BIN\isql.exe"
set inputfile="C:\Users\UtkinI\Documents\tee\query.sql"
set outputfile="C:\Users\UtkinI\Documents\tee\output_%Date:~6,4%%Date:~3,2%%Date:~0,2%.txt"

%isql% -i %inputfile% -o %outputfile% -q

CONNECT 'E:\Torgovlya54\MAIN.GDB' user 'SYSDBA' password 'masterkey';
SELECT C.CODE, C.NAME, T.TRANZDATE, max(T.TRANZTIME), T.INFOSTR, sum(T.SUMM) FROM DOCUMENT D LEFT JOIN TRANZT T ON D.ID = T.DOCUMENTID JOIN CLIENT C ON T.INFO2 = C.CODE WHERE T.TRANZDATE = cast('now' as date) and D.STATE = 1 AND D.ISFISCAL = 1 AND T.TRANZTYPE = '36' and T.INFO = '8' GROUP BY C.CODE, C.NAME, T.TRANZDATE, T.INFOSTR;
commit work;

SELECT C.CODE AS "Табельный", TRIM(C.NAME) AS "Ф.И.О.", T.TRANZDATE AS "Дата", max(T.TRANZTIME) AS "Время", T.INFOSTR AS "Карта", TRIM(sum(T.SUMM)) AS "Сумма"
FROM DOCUMENT D
    LEFT JOIN TRANZT T ON D.ID = T.DOCUMENTID
         JOIN CLIENT C ON T.INFO2 = C.CODE
WHERE T.TRANZDATE = cast('now' as date) and D.STATE = 1 AND D.ISFISCAL = 1 AND T.TRANZTYPE = '36' and T.INFO = '8'
GROUP BY C.CODE, C.NAME, T.TRANZDATE, T.INFOSTR;

SELECT TRIM(C.CODE) || ' ' || TRIM(C.NAME)|| ' ' || TRIM(T.INFOSTR) || ' ' || TRIM(sum(T.SUMM))
FROM DOCUMENT D
    LEFT JOIN TRANZT T ON D.ID = T.DOCUMENTID
         JOIN CLIENT C ON T.INFO2 = C.CODE
WHERE T.TRANZDATE = cast('now' as date) and D.STATE = 1 AND D.ISFISCAL = 1 AND T.TRANZTYPE = '36' and T.INFO = '8'
GROUP BY C.CODE, C.NAME, T.TRANZDATE, T.INFOSTR;