balance query - SQL Server Forums

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

SQL Server 2005 Forums

Transact-SQL (2005)

balance query

Author

Topic

UNSAL
Starting Member

17 Posts

Posted - 2008-08-29 : 03:41:18

I TO MAKE date between balance query but why no running
01.01.2008 and 31.12.2008 between fkod FBORC-FALACAK=BAKIYE
querry all mixed

querry running but no bettween and no fkod

Im to want sql querry running beloww

Ftarih(date) fkod faciklama fborc(debit) falacak(credit) fbakiye (balance)
xxxxx 10001 balance 1250 € 0 1250 €
01.08.2008 10001 xx invoice 1000 € 0 2250 €
05.08.2008 10001 xx credit kart 0 250 € 2000 €

SELECT FISHRK.FTARIH, FISHRK.FKOD, FISHRK.FACIKLAMA, FISHRK.FBORC, FISHRK.FALACAK, SUM(FISHRKKUM.FBORC) - SUM(FISHRKKUM.FALACAK)
AS Bakiye
FROM FISHRK AS FISHRK CROSS JOIN
FISHRK AS FISHRKKUM
WHERE (FISHRK.FTARIH < @FTARIH1) AND (FISHRK.FKOD = @FKOD) OR
(FISHRK.FTARIH < @FTARIH1) AND (@FKOD IS NULL) OR
(FISHRK.FKOD = @FKOD) AND (@FTARIH1 IS NULL) OR
(@FKOD IS NULL) AND (@FTARIH1 IS NULL) AND (FISHRK.FBORC <= FISHRKKUM.FBORC) OR
(FISHRK.FBORC = FISHRKKUM.FBORC) AND (FISHRK.FADI = FISHRKKUM.FADI) AND (FISHRK.FALACAK <= FISHRKKUM.FALACAK) OR
(FISHRK.FADI = FISHRKKUM.FADI) AND (FISHRK.FALACAK = FISHRKKUM.FALACAK)
GROUP BY FISHRK.FTARIH, FISHRK.FKOD, FISHRK.FACIKLAMA, FISHRK.KUR, FISHRK.FBORC, FISHRK.FALACAK
UNION ALL
SELECT FISHRK.FTARIH, FISHRK.FKOD, FISHRK.FACIKLAMA, FISHRK.FBORC, FISHRK.FALACAK, SUM(FISHRKKUM.FBORC) - SUM(FISHRKKUM.FALACAK)
AS Bakiye
FROM FISHRK AS FISHRK CROSS JOIN
FISHRK AS FISHRKKUM
WHERE (FISHRK.FTARIH BETWEEN @FTARIH1 AND @FTARIH2) AND (FISHRK.FKOD = @FKOD) OR
(FISHRK.FTARIH BETWEEN @FTARIH1 AND @FTARIH2) AND (@FKOD IS NULL) OR
(FISHRK.FKOD = @FKOD) AND (@FTARIH1 IS NULL) AND (FISHRK.FBORC <= FISHRKKUM.FBORC) OR
(@FKOD IS NULL) AND (@FTARIH1 IS NULL) AND (FISHRK.FBORC <= FISHRKKUM.FBORC) OR
(FISHRK.FBORC = FISHRKKUM.FBORC) AND (FISHRK.FADI = FISHRKKUM.FADI) AND (FISHRK.FALACAK <= FISHRKKUM.FALACAK) OR
(FISHRK.FADI = FISHRKKUM.FADI) AND (FISHRK.FALACAK = FISHRKKUM.FALACAK)
GROUP BY FISHRK.FTARIH, FISHRK.FKOD, FISHRK.FACIKLAMA, FISHRK.KUR, FISHRK.

UNSAL OSMA/TURKEY/ANTALYA

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2008-08-29 : 03:59:48

Did nt get what you're trying to do. post some sample data and explain what you want to get as output.

UNSAL
Starting Member

17 Posts

Posted - 2008-08-29 : 04:08:23

Im to want sql querry running beloww

Ftarih(date) fkod faciklama fborc(debit) falacak(credit) fbakiye (balance)
xxxxx 10001 balance 1250 € 0 1250 €
01.08.2008 10001 xx invoice 1000 € 0 2250 €
05.08.2008 10001 xx credit kart 0 250 € 2000 €

UNSAL OSMA/TURKEY/ANTALYA

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2008-08-29 : 04:17:23

out of what data? you need to give some source data as well and explain rule to get the above output

UNSAL
Starting Member

17 Posts

Posted - 2008-08-29 : 04:49:25

This strategic querry formulate
but then date bettween and ACCOUNTCODE and opening balance example please write.thanks

DATA TABLE NAME : FISHRK
COLOMUN NAME : ACCOUNTCODE,DATE,DESCRIPTION,DEBIT,CREDIT,BALANCE

EXAMPLE;
ACCOUNTCODE DATE DESCRIPTION DEBIT CREDIT BALANCE
---------- ---- opening balance 120-€ 0-€ 120-€
122221111 01.05 INVOICE 155 25-€ 95-€

UNSAL OSMA/TURKEY/ANTALYA

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2008-08-29 : 05:02:19

Search for Running Total in this Forum

Madhivanan

Failing to plan is Planning to fail

UNSAL
Starting Member

17 Posts

Posted - 2008-08-29 : 06:48:42

I'm look not understand.
give me example.

UNSAL OSMA/TURKEY/ANTALYA

UNSAL
Starting Member

17 Posts

Posted - 2008-08-30 : 02:05:23

hellooo
to me helper this subject.
example to show date between balance query.

UNSAL OSMA/TURKEY/ANTALYA