sql 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)

sql query

Author

Topic

UNSAL
Starting Member

17 Posts

Posted - 2008-08-27 : 09:08:30

I TO MAKE date between balance query but why errorr
01.01.2008 and 31.12.2008 between fkod FBORC-FALACAK=BAKIYE WHY ERROR ????????

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.FBORC, FISHRK.FALACAK

UNSAL OSMA/TURKEY/ANTALYA

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2008-08-27 : 10:08:14

Cant spot anything syntax wise. what's the error you're getting?

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.FBORC, FISHRK.FALACAK

UNSAL
Starting Member

17 Posts

Posted - 2008-08-28 : 06:37:20

NO errorr , querry running but no bettween and no fkod

Im to want sql querry running beloww

fkod faciklama fborc(debit) falacak(credit) fbakiye (balance)

UNSAL OSMA/TURKEY/ANTALYA

UNSAL
Starting Member

17 Posts

Posted - 2008-08-28 : 06:40:47

NO errorr , 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 €

UNSAL OSMA/TURKEY/ANTALYA

UNSAL
Starting Member

17 Posts

Posted - 2008-08-28 : 06:44:10

querry all mixed

UNSAL OSMA/TURKEY/ANTALYA

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources