Diferencia entre revisiones de «CBU's otros Bancos»
De Wiki
(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