Diferencia entre revisiones de «CBU's otros Bancos»

De Wiki
Saltar a: navegación, buscar
(Página nueva: USE d:\tempo_otros.dbf IN 0 EXCLUSIVE select substr(alltrim(cbu),1,4) as bco,substr(alltrim(cbu),5,4) as suc,substr(alltrim(cbu),12,11) as cta,; *; from tempo_otros; order by 1,2,3...)
 
 
(No se muestra una edición intermedia del mismo usuario)
Línea 1: Línea 1:
 
USE d:\tempo_otros.dbf IN 0 EXCLUSIVE
 
USE d:\tempo_otros.dbf IN 0 EXCLUSIVE
  
select substr(alltrim(cbu),1,4) as bco,substr(alltrim(cbu),5,4) as suc,substr(alltrim(cbu),12,11) as cta,;
+
select substr(alltrim(cbu),1,4) as bco,substr(alltrim(cbu),5,4) as suc,substr(alltrim(cbu),12,11);
*;
+
as cta,*;
 
  from tempo_otros;
 
  from tempo_otros;
order by 1,2,3
+
order by 1,2,3
  
 
*Consulta de importes y cantidad de agentes por Bancos (para Bancos distintos a Bco Nacion)
 
*Consulta de importes y cantidad de agentes por Bancos (para Bancos distintos a Bco Nacion)
select substr(alltrim(cbu),1,4) as bco, sum(importe) as imp,count(*) as cant_agentes;
+
select substr(alltrim(cbu),1,4) as bco, sum(importe) as imp,count(*) as cant_agentes;
 
  from tempo_otros;
 
  from tempo_otros;
order by 1 group by bco
+
order by 1 group by bco into table "T:\acreditacion\0612\estad_otros_bcos

Revisión actual del 15:20 4 jul 2012

USE d:\tempo_otros.dbf IN 0 EXCLUSIVE

select substr(alltrim(cbu),1,4) as bco,substr(alltrim(cbu),5,4) as suc,substr(alltrim(cbu),12,11);
as cta,*;
from tempo_otros;
order by 1,2,3
  • Consulta de importes y cantidad de agentes por Bancos (para Bancos distintos a Bco Nacion)
select substr(alltrim(cbu),1,4) as bco, sum(importe) as imp,count(*) as cant_agentes;
from tempo_otros;
order by 1 group by bco into table "T:\acreditacion\0612\estad_otros_bcos