Skip to content

Instantly share code, notes, and snippets.

@abacha
Created May 11, 2016 12:41
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save abacha/2d40f5df5a7e7526730e41dce09ddb5c to your computer and use it in GitHub Desktop.
Save abacha/2d40f5df5a7e7526730e41dce09ddb5c to your computer and use it in GitHub Desktop.
String sql = "SELECT ID_EMPRESA"
+ " ,ID_EVENTO"
+ " ,ID_OPERACAO"
+ " ,DT_MOVTO"
+ " ,VLR_EVENTO"
+ " ,DS_EVENTO"
+ " ,NM_EMPRESA"
+ " ,NR_CONTACREDITO"
+ " ,DV_CONTACREDITO"
+ " ,NR_CONTADEBITO"
+ " ,DV_CONTADEBITO"
+ " ,ID_EVENTO_REVERSAO"
+ " ,MP_OCORRENCIAS"
+ " ,NM_METODO"
+ " ,TP_EVENTO"
+ " ,CD_OPERACAO"
+ " ,DS_CLASSEPAPEL"
+ " FROM CRKCPR.DBO.CPR_VW_EVTCONTABILDIA WITH (NOLOCK)"
+ " WHERE DT_MOVTO = ? AND NR_CONTACREDITO NOT IN('11111','22222','111112','222222')";
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment