Pesquisar na Comunidade
Mostrando resultados para as tags ''divide por zero''.
Encontrado(s) 1 registro
-
Dúvida Com Erro "divide Por Zero Error Encountered"
raphaelluizschettino postou um tópico no fórum [RM] Scripts SQL e Bancos de Dados
Pessoal minha consulta para vendas e seus respectivos vendedores estava funcionando de boa, só que nesse mês apareceu o erro "Divide por zero error encountered" alguém sabe o que significa? Marquei em negrito onde uso "/" divisão, mas tentei com if e não deu certo, alguma sugestão? ----------------------------------------- SELECT TPRD.DESCRICAO AS PRODUTOS, TMOV.CODFILIAL AS FILIAL, TMOV.PLACA AS PLACA, FCFO.CODCFO AS COD_CLI, FCFO.NOMEFANTASIA AS FANTASIA, FCFO.NOME AS CLIENTE, FCFO.RUA AS ENDERECO, FCFO.BAIRRO AS BAIRRO, GMUNICIPIO.NOMEMUNICIPIO MUNICÍPIO, DATEPART(YEAR,TMOV.DATAEMISSAO) AS ANO, DATEPART(MONTH,TMOV.DATAEMISSAO) AS MES, DATEPART(DAY,TMOV.DATAEMISSAO) AS DIA, SUM(TITMMOV.QUANTIDADE) AS FORMA, (CASE WHEN TPRD.PESAVEL=1 THEN SUM(TITMMOV.VALOROPFRM1) ELSE SUM(TITMMOV.QUANTIDADE*TPRD.PESOLIQUIDO) END) AS KG, SUM(TITMMOV.VALOROPFRM2) AS VALOR, SUM(TITMMOV.VALOROPFRM2) AS PERC, (CASE WHEN TTMV.CODTMV IN ('2.2.01','2.2.09','2.2.13','2.2.16','2.2.25','2.2.28','2.2.30','2.2.31') THEN ' VENDAS' ELSE CASE WHEN TTMV.CODTMV LIKE '2.2.04' THEN 'BONIFICAÇÃO' ELSE CASE WHEN TTMV.CODTMV IN('1.2.34','1.2.50','1.2.02','1.2.20','1.2.23','1.2.25') THEN 'VENDAS CANCELADAS' ELSE CASE WHEN TTMV.CODTMV IN ('1.2.99') THEN 'REFATURADAS' END END END END) AS TIPO_VENDA, TVEN.NOME AS VENDEDOR, (SUM(TITMMOV.VALOROPFRM2)/(CASE WHEN TPRD.PESAVEL=1 THEN SUM(TITMMOV.VALOROPFRM1) ELSE SUM(TITMMOV.QUANTIDADE*TPRD.PESOLIQUIDO) END)) AS PRATICADO, TRPR.NOMEFANTASIA AS SUPERVISOR, SUBSTRING(TPRD.CODIGOPRD,1,5) AS FAMILIA, (CASE WHEN SUBSTRING(TPRD.CODIGOPRD,1,5) IN ('01.06') THEN 'FINOS' ELSE 'DIAaDIA' END) AS LINHA, SUBSTRING(TPRD.CODIGOPRD,1,8) AS CODPRD, TMOV.NUMEROMOV AS NF, TCPG.NOME AS PRAZO, TPRD.CODIGOAUXILIAR AS AUX, TPRD.NOMEFANTASIA AS DESCRIÇÃO FROM FCFO, GCOLIGADA, GFILIAL, GMUNICIPIO, TITMMOV, TMOV, TPRD, TTMV,TRPR,TVEN, FCFODEF, TCPG WHERE (GFILIAL.CODCOLIGADA = GCOLIGADA.CODCOLIGADA) AND (TMOV.CODCOLIGADA = GCOLIGADA.CODCOLIGADA) AND (TMOV.CODFILIAL = GFILIAL.CODFILIAL) AND (TMOV.IDMOV = TITMMOV.IDMOV) AND (TMOV.CODCFO = FCFO.CODCFO) AND (TMOV.CODTMV = TTMV.CODTMV) AND (TITMMOV.IDPRD = TPRD.IDPRD) AND (TTMV.CODCOLIGADA = GCOLIGADA.CODCOLIGADA) AND (TTMV.CODCOLIGADA = GCOLIGADA.CODCOLIGADA) AND (TMOV.CODCPG=TCPG.CODCPG) AND (TTMV.CODTMV IN ('2.2.01','2.2.13','2.2.09','2.2.16','2.2.25','2.2.28','2.2.30','2.2.31','2.2.04','1.2.02','1.2.20','1.2.23','1.2.25','1.2.34','1.2.50','1.2.99')) AND (TPRD.CODCOLIGADA = GCOLIGADA.CODCOLIGADA) AND FCFO.CODMUNICIPIO=GMUNICIPIO.CODMUNICIPIO AND FCFO.CODETD=GMUNICIPIO.CODETDMUNICIPIO AND TMOV.STATUS NOT IN ('C') AND TMOV.DATAEMISSAO>=:DATA_INICIAL_D AND TMOV.DATAEMISSAO<=:DATA_FINAL_D AND FCFO.CODCFO=FCFODEF.CODCFO AND FCFODEF.CODVEN*=TVEN.CODVEN AND FCFODEF.CODRPR*=TRPR.CODRPR GROUP BY TPRD.DESCRICAO, GCOLIGADA.NOME, TMOV.CODFILIAL , FCFO.CODCFO, FCFO.RUA, FCFO.BAIRRO, FCFO.NOME, FCFO.NOMEFANTASIA,GMUNICIPIO.NOMEMUNICIPIO,TMOV.DATAEMISSAO,TTMV.CODTMV,TPRD.PESAVEL, TITMMOV.QUANTIDADE,TPRD.PESOLIQUIDO,TVEN.NOME,TRPR.NOMEFANTASIA,TPRD.CODIGOPRD, TMOV.NUMEROMOV, TCPG.NOME, TPRD.CODIGOAUXILIAR, TPRD.NOMEFANTASIA, TMOV.PLACA UNION SELECT TPRD.DESCRICAO AS PRODUTOS, TMOV.CODFILIAL AS FILIAL, TMOV.PLACA AS PLACA, FCFO.CODCFO AS COD_CLI, FCFO.NOME AS CLIENTE, FCFO.NOMEFANTASIA AS FANTASIA, FCFO.RUA AS ENDERECO, FCFO.BAIRRO AS BAIRRO, GMUNICIPIO.NOMEMUNICIPIO MUNICÍPIO, DATEPART(YEAR,TMOV.DATASAIDA) AS ANO, DATEPART(MONTH,TMOV.DATASAIDA) AS MES, DATEPART(DAY,TMOV.DATASAIDA) AS DIA, SUM(TITMMOV.QUANTIDADE) AS FORMA, (CASE WHEN TPRD.PESAVEL=1 THEN SUM(TITMMOV.VALOROPFRM1) ELSE SUM(TITMMOV.QUANTIDADE*TPRD.PESOLIQUIDO) END) AS KG, SUM(TITMMOV.VALOROPFRM2) AS VALOR, SUM(TITMMOV.VALOROPFRM2) AS PERC, (CASE WHEN TTMV.CODTMV IN ('1.2.13','1.2.14','1.2.15','1.2.35') THEN 'DEVOLUÇÃO' END ) AS TIPO_VENDA, TVEN.NOME AS VENDEDOR, (SUM(TITMMOV.VALOROPFRM2)/(CASE WHEN TPRD.PESAVEL=1 THEN SUM(TITMMOV.VALOROPFRM1) ELSE SUM(TITMMOV.QUANTIDADE*TPRD.PESOLIQUIDO) END)) AS PRATICADO, TRPR.NOMEFANTASIA AS SUPERVISOR, SUBSTRING(TPRD.CODIGOPRD,1,5) AS FAMILIA, (CASE WHEN SUBSTRING(TPRD.CODIGOPRD,1,5) IN ('01.06') THEN 'FINOS' ELSE 'DIAaDIA' END) AS LINHA, SUBSTRING(TPRD.CODIGOPRD,1,8) AS CODPRD, TMOV.NUMEROMOV AS NF, TCPG.NOME AS PRAZO, TPRD.CODIGOAUXILIAR AS AUX, TPRD.NOMEFANTASIA AS DESCRIÇÃO FROM FCFO, GCOLIGADA, GFILIAL, GMUNICIPIO, TITMMOV, TMOV, TPRD, TTMV,TRPR,TVEN, FCFODEF, TCPG WHERE (GFILIAL.CODCOLIGADA = GCOLIGADA.CODCOLIGADA) AND (TMOV.CODCOLIGADA = GCOLIGADA.CODCOLIGADA) AND (TMOV.CODFILIAL = GFILIAL.CODFILIAL) AND (TMOV.IDMOV = TITMMOV.IDMOV) AND (TMOV.CODCFO = FCFO.CODCFO) AND (TMOV.CODTMV = TTMV.CODTMV) AND (TITMMOV.IDPRD = TPRD.IDPRD) AND (TTMV.CODCOLIGADA = GCOLIGADA.CODCOLIGADA) AND (TTMV.CODCOLIGADA = GCOLIGADA.CODCOLIGADA) AND (TMOV.CODCPG=TCPG.CODCPG) AND (TTMV.CODTMV IN ('1.2.13','1.2.14','1.2.15','1.2.35')) AND (TPRD.CODCOLIGADA = GCOLIGADA.CODCOLIGADA) AND FCFO.CODMUNICIPIO=GMUNICIPIO.CODMUNICIPIO AND FCFO.CODETD=GMUNICIPIO.CODETDMUNICIPIO AND TMOV.STATUS NOT IN ('C') AND TMOV.DATASAIDA>=:DATA_INICIAL_D AND TMOV.DATASAIDA<=:DATA_FINAL_D AND FCFO.CODCFO=FCFODEF.CODCFO AND FCFODEF.CODVEN*=TVEN.CODVEN AND FCFODEF.CODRPR*=TRPR.CODRPR GROUP BY TPRD.DESCRICAO, GCOLIGADA.NOME, TMOV.CODFILIAL , FCFO.CODCFO, FCFO.RUA, FCFO.BAIRRO, FCFO.NOME, FCFO.NOMEFANTASIA,GMUNICIPIO.NOMEMUNICIPIO,TMOV.DATASAIDA,TTMV.CODTMV,TPRD.PESAVEL, TITMMOV.QUANTIDADE,TPRD.PESOLIQUIDO,TVEN.NOME,TRPR.NOMEFANTASIA,TPRD.CODIGOPRD, TMOV.NUMEROMOV, TCPG.NOME, TPRD.CODIGOAUXILIAR, TPRD.NOMEFANTASIA, TMOV.PLACA- 2 respostas
-
- divide por zero
- error
-
(e 2 outras)
Tags: