Skip to content

Instantly share code, notes, and snippets.

@primogf

primogf/qry_conversao_srtToValue.sql

Created November 11, 2016 19:13
Show Gist options
  • Save primogf/ac8de78c82f86e34b1754e82eee95244 to your computer and use it in GitHub Desktop.
Save primogf/ac8de78c82f86e34b1754e82eee95244 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
qry_conversao_srtToValue.sql
SELECT COUNT(1) FROM erp_parceiro_classificacoes where id_classificacao = 8 and cast(replace(replace(replace(replace(value,"R$","")," ",""),".",""),",",".") AS decimal(10,2)) BETWEEN 150 AND 1000;
SELECT id_parceiro, id_classificacao, cast(replace(replace(replace(replace(value,"R$","")," ",""),".",""),",",".") AS decimal(10,2)) FROM erp_parceiro_classificacoes where id_classificacao = 8 and cast(replace(replace(replace(replace(value,"R$","")," ",""),".",""),",",".") AS decimal(10,2)) BETWEEN 150 AND 1000;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment