SELECT TOP 10000000 k.sysmodified,
                    k.id,
                    LTRIM(RTRIM(k.budget))    AS budget,
                    k.YEAR,
                    LTRIM(RTRIM(k.MONTH))     AS MONTH,
                    k.amount,
                    k.quantity,
                    itemcode,
                    k.resource,
                    k.itemcodedescription,
                    LTRIM(RTRIM(k.debcode))   AS debcode,
                    LTRIM(RTRIM(k.warehouse)) AS warehouse,
                    k.project,
                    k.unitcode                AS costunit,
                    k.costcenter
FROM   kstoregap2fill k (nolock)

SELECT TOP 10000000 ioddashsboardvendas.id,
                    LTRIM(RTRIM(warehouse)) AS warehouse,
                    itemassortment,
                    artigo,
                    iccode1,
                    iccode2,
                    iccode3,
                    iccode4,
                    iccode5,
                    iccode6,
                    iccode7,
                    iccode8,
                    iccode9,
                    iccode10,
                    LTRIM(RTRIM(debnr))     AS debnr,
                    ioddashsboardvendas.res_id,
                    bkjrcode,
                    MONTH,
                    DAY,
                    ( credit - debit )      AS Valor,
                    aantal
FROM   ioddashsboardvendas (nolock)