DECLARE  @Partition BIGINT
DECLARE @DATAAREAID VARCHAR(10)
DECLARE @TransId        BIGINT
DECLARE @DATEFROM       DateTime
DECLARE @DATETO     DateTime
DECLARE @TAXCODE        VARCHAR(100)

SET @partition = 5637144576
SET @transID = 5646392900
SET @dataAreaId = 'ltr'
SET @dateFrom = '2018-09-01'
SET @dateTo = '2018-09-30'
SET @taxcode = ''

    SELECT
        w.CUSTVENDNAME_PL
        ,id.INVOICE
        ,@DATAAREAID
        , @Partition
        , ROW_NUMBER() OVER (
                ORDER BY TAXCODE
                ) + isNull((
                    SELECT MAX(RECID)
                    FROM TaxVatRegisterTmp WITH (NOLOCK)
                    ), 0)
        , @TransId
        , t.VOUCHER                                                                             AS 'Załącznik'
        , FORMAT(w.VATDUEDATE_W , 'yyy-MM-dd')                                                  AS 'Data rejestru VAT'
        , FORMAT(t.TRANSDATE, 'yyy-MM-dd')                                                      AS 'Data księgowania'
        , FORMAT(w.DOCUMENTDATE_PL , 'yyy-MM-dd')                                               AS 'Data dokumentu'
        , w.VATNUM_PL                                                                           AS 'NIP'
        , t.TAXCODE                                                                             AS 'Kod podatku'
        , CAST(t.TAXVALUE  AS DECIMAL(30,2))                                                    AS 'Stawka VAT %'
        , CAST(SUM(t.TAXBASEAMOUNT) AS DECIMAL(30,2))                                   AS 'Podstawa opodatkowania'
        , CAST(SUM(t.TAXAMOUNT) AS DECIMAL(30,2))                                       AS 'Kwota podatku'
        --, cast((sum(t.TAXAMOUNT) * (-1))   + (sum(t.TAXBASEAMOUNT) * (-1)) as decimal(30,2))  AS 'Kwota brutto'
    FROM TAXTRANS t
    JOIN TAXTRANS_W w ON w.TAXTRANS = t.RECID AND w.DATAAREAID = t.DATAAREAID AND w.PARTITION = t.PARTITION
    OUTER APPLY
    (
        SELECT INVOICE
            FROM CUSTTRANS ct
                WHERE ct.TRANSDATE = t.TRANSDATE AND ct.VOUCHER = t.VOUCHER AND ct.DATAAREAID = t.DATAAREAID AND ct.PARTITION = t.PARTITION
        UNION
        SELECT INVOICE
            FROM VENDTRANS vt
                WHERE vt.TRANSDATE = t.TRANSDATE AND vt.VOUCHER = t.VOUCHER AND vt.DATAAREAID = t.DATAAREAID AND vt.PARTITION = t.PARTITION
    ) id
    WHERE t.DATAAREAID = @DATAAREAID AND t.PARTITION = @Partition
    AND w.VATDUEDATE_W BETWEEN  @DATEFROM AND @DATETO
    AND (@TAXCODE = '' OR (@TAXCODE <> '' AND t.TAXCODE = @TAXCODE))
    AND t.TAXDIRECTION IN (1,4,108)
    GROUP BY t.VOUCHER, w.VATDUEDATE_W , t.TRANSDATE, w.DOCUMENTDATE_PL, w.VATNUM_PL, t.TAXCODE, t.TAXVALUE, w.CUSTVENDNAME_PL, id.INVOICE
    ORDER BY t.TRANSDATE, t.TAXVALUE

    --Zwiekszam następną wartość RECID w systemie
    DECLARE @maxRecId BIGINT;
    DECLARE @recVersion INT;
    DECLARE @TableId INT = 106436;

     SET @maxRecId = (SELECT MAX(RECID)
            FROM TaxVatRegisterTmp WITH (NOLOCK))

     SELECT @recVersion = [RECVERSION] FROM [SYSTEMSEQUENCES] WHERE [TABID] = @TableId

     UPDATE [SYSTEMSEQUENCES] SET [NEXTVAL] = @maxRecId+1, [RECVERSION] = @recVersion+1 WHERE [TABID] = @TableId

     -- SUMY
     --EXEC TAXREGISTER_PURCH_SUMOnly @Partition, @DATAAREAID, @TransId, @DATEFROM, @DATETO, @TAXCODE