Hola,
Con este query
SELECT SBI_001.dbo.JDT1.Account,
DatePart("m",SBI_001.dbo.JDT1.Refdate) AS months,
SUM (SBI_001.dbo.JDT1.SYSDeb - SBI_001.dbo.JDT1.SYSCred)
Balance_SYS
FROM SBI_001.dbo.JDT1
WHERE SBI_001.dbo.JDT1.Account LIKE '1%' and
SBI_001.dbo.JDT1.TransType <> '-3'
AND DatePart("yyyy",SBI_001.dbo.JDT1.Refdate) = '2009'
GROUP BY SBI_001.dbo.JDT1.Account, DatePart
("yyyy",SBI_001.dbo.JDT1.Refdate),
DatePart("m",SBI_001.dbo.JDT1.Refdate)
Obtengo:
Account months Balance_SYS
10003321 9 54000
10007885 7 -133905
10006011 10 79729
Como uso pivot para obtener
Account 1 2 3 4 5
6 7 8 9 10 11 12
10003321
54000
10007885
-133905
10006011
79729
Leer las respuestas