SELECT TOP ( 100 ) PERCENT
reknr,
SUM(CASE WHEN MONTH(da) = 1 THEN bdr
ELSE 0
END) AS Balance_1,
SUM(CASE WHEN MONTH(da) = 2 THEN bdr
ELSE 0
END) AS Balance_2,
SUM(CASE WHEN MONTH(da) = 3 THEN bdr
ELSE 0
END) AS Balance_3,
SUM(CASE WHEN MONTH(da) = 4 THEN bdr
ELSE 0
END) AS Balance_4,
SUM(CASE WHEN MONTH(da) = 5 THEN bdr
ELSE 0
END) AS Balance_5,
SUM(CASE WHEN MONTH(da) = 6 THEN bdr
ELSE 0
END) AS Balance_6,
SUM(CASE WHEN MONTH(da) = 7 THEN bdr
ELSE 0
END) AS Balance_7,
SUM(CASE WHEN MONTH(da) = 8 THEN bdr
ELSE 0
END) AS Balance_8,
SUM(CASE WHEN MONTH(da) = 9 THEN bdr
ELSE 0
END) AS Balance_9,
SUM(CASE WHEN MONTH(da) = 10 THEN bdr
ELSE 0
END) AS Balance_10,
SUM(CASE WHEN MONTH(da) = 11 THEN bdr
ELSE 0
END) AS Balance_11,
SUM(CASE WHEN MONTH(da) = 12 THEN bdr
ELSE 0
END) AS Balance_12

FROM dbo.gbkt WITH ( NOLOCK )
WHERE ( trans IN ( 'N', 'C', 'P' ) )
AND ( Count <= 10 )
AND ( transsub<> 'X' )
AND bkjr= '2012'
AND periode BETWEEN 1 AND 12
AND (rek in (' 80140010',
' 80140020',
' 80140030',
' 80140040',
' 80140050',
' 80140060',
' 80150010',
' 80150030',
' 80150040',
' 80150050',
' 80150070',
' 80150080',
' 80160030',
' 80160150',
' 80160170',
' 70080010'))
AND kstpl IN (40414000,40414100)