Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT COUNT(contrato) can, contrato,estado_corte,NOMBRECLIENTE,CEDNIT,DIRECCION,CICLO,departamento,CIUDAD,ESTRATO FROM (
- SELECT sc.SUSCCODI CONTRATO, cor.escodesc estado_corte, UPPER(sc.SUSCNOMB) NOMBRECLIENTE,sc.SUSCNITC CEDNIT
- ,dc.dccodico DIRECCION,sc.susccicl CICLO,de.depadesc departamento, lo.locanomb CIUDAD,scat.sucadesc ESTRATO, sesuserv
- FROM suscripc sc, servsusc ss,flex.departam de, flex.localida lo, flex.subcateg scat, flex.estacort cor, dicocobr dc
- WHERE sc.susccodi = ss.sesususc
- AND sc.suscdcco = dc.dccocodi
- AND ss.sesusesb = -1 --Servicios Principales
- --and ss.sesuesco in ('11','1','92') --Estados de corte facturables
- AND ss.sesuesco NOT IN ('100') --Estados de corte facturables
- AND sc.suscdepa = de.depacodi
- AND sc.suscdepa = lo.locadepa
- AND sc.suscloca = lo.locacodi
- AND ss.sesuesco = cor.escocodi
- AND ss.sesucate = scat.sucacate
- AND ss.sesusuca = scat.sucacodi
- --and ss.sesuserv not in ('8111','8083')
- AND suscnitc = '43163166'
- )
- GROUP BY contrato,estado_corte,NOMBRECLIENTE,CEDNIT,DIRECCION,CICLO,departamento,CIUDAD,ESTRATO
- ORDER BY ESTADO_CORTE ASC
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement