I want to do, but somehow I could not balance the system moving.
SELECT TARIH,
ACIKLAMA,BORC,ALACAK
from ( SELECT CONVERT(DATETIME,a.[MUHHARTAR],104) as TARIH
,a.[MUHHARMUHKOD] as KOD
,a.[MUHHARACIKLAMA] as ACIKLAMA
,case a.[MUHHARBATIPI]
when '1' then CONVERT(DECIMAL(18,2),a.MUHHARTUTAR)
END AS BORC
,CASE a.[MUHHARBATIPI]
WHEN '2' THEN CONVERT(DECIMAL(18,2),a.MUHHARTUTAR)
END AS ALACAK
FROM [dbo].[MUHHAR] as a WHERE MUHHARMUHKOD='120 01 395' )
as a
group by TARIH,ACIKLAMA,BORC,ALACAK
order by TARIH ASC
I SAID I WANT TO DO
TARIH ACIKLAMA BORC ALACAK BAKIYE
07.08.2012 TCA INSAAT 4355,00 0,00 4355,00
07.08.2012 TCA INSAAT 200,00 0,00 4555,00
07.08.2012 TCA INSAAT 00,00 500,00 4055,00
