Ver Mensaje Individual
  #3  
Antiguo 21-05-2011
overloaded overloaded is offline
Registrado
NULL
 
Registrado: may 2011
Posts: 2
Reputación: 0
overloaded Va por buen camino
podrias hacerlo así:

Código SQL [-]
SELECT 
(
SELECT 
SUM(GL20000.DEBITAMT) - SUM(GL20000.CRDTAMNT)
FROM
  GL20000
  INNER JOIN dbo.GL00100 ON (GL20000.ACTINDX = dbo.GL00100.ACTINDX)
  WHERE
  GL00100.MNACSGMT = '51504010' and
  GL20000.TRXDATE BETWEEN '20100101' and '20100131'
) AS ENERO,
(
SELECT 
SUM(GL20000.DEBITAMT) - SUM(GL20000.CRDTAMNT) 
FROM
  GL20000
  INNER JOIN dbo.GL00100 ON (GL20000.ACTINDX = dbo.GL00100.ACTINDX)
  WHERE
  GL00100.MNACSGMT = '51504010' and
  GL20000.TRXDATE BETWEEN '20100201' and '20100228'
) AS FEBRERO,
(
SELECT 
SUM(GL20000.DEBITAMT) - SUM(GL20000.CRDTAMNT)
FROM
  GL20000
  INNER JOIN dbo.GL00100 ON (GL20000.ACTINDX = dbo.GL00100.ACTINDX)
  WHERE
  GL00100.MNACSGMT = '51504010' and
  GL20000.TRXDATE BETWEEN '20100301' and '20100331'
) AS MARZO,
.....
FROM DUAL
Responder Con Cita