HTML |
---|
<center><font size="5000"> MELHORAR A QUALIDADE DOS DADOS EM 70% </font></center> |
bgColor | Black |
---|---|
orientation | vertical |
height | 600 |
width | 1200 |
showShapes | false |
type | line |
SQL | ||||||||||
---|---|---|---|---|---|---|---|---|---|---|
| ||||||||||
select 'ANTES' AS Tipo, sum(totalErros) as Reg, sum(tipoErros) as Itens, count(*) as Tot from ( select nuSerie, sum(qtd) as totalErros, count(*) as tipoErros from esanTesteAuditorErroInicio where tipoValidacao = 'V' group by nuSerie ) union select 'DEPOIS' as Tipo, sum(totalErros) as Reg, sum(tipoErros) as Itens, count(*) as Tot from ( select nuSerie, sum(qtd) as totalErros, count(*) as tipoErros from esanTesteFirebirdErro where tipoValidacao = 'V' group by nuSerie ) |