Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 SQL sum total problem

Author  Topic 

Black_Trouble
Starting Member

21 Posts

Posted - 2012-11-27 : 10:12:50
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


[img]

[/img]

sodeep
Master Smack Fu Yak Hacker

7174 Posts

Posted - 2012-11-27 : 10:22:01
Your question is not clear.

Here is how: http://weblogs.sqlteam.com/brettk/archive/2005/05/25/5276.aspx
Go to Top of Page
   

- Advertisement -