Message 8115, Level 16, State 5 - Arithmetic overflow error converting numeric to varchar data type

0

I can not find what's wrong with these conversions:

INSERT INTO @RESULTADO
                SELECT @DATA_REF                             as data_ref, 
                       @EMPRESA                              as empresa, 
                       @LOCAL                                as local_loja,
                       Month(@DATA_REF)                      as mes, 
                       Year(@DATA_REF)                       as ano, 
                       Sum(ISNULL(VE.EXTSLDPOS * VE.PRECO1, 0))  as saldo, 
                       Cast(Month(@DATA_REF) AS VARCHAR(2)) + '/' 
                       + Cast(Year(@DATA_REF) AS VARCHAR(4)) AS ANO_MES,

-- AQUI DAR O ERRO.


DECLARE @RESULTADO TABLE 
  ( 
     data_ref       DATETIME, 
     empresa        INT, 
     mes            INT, 
     ano            INT, 
     saldo          DECIMAL(15, 7), 
     ANO_MES        VARCHAR(7),
     local_loja     INT,
     DESCRICAO      VARCHAR(30) 
  )  
    
asked by anonymous 26.07.2018 / 14:36

0 answers