Aşğaıdaki sorgunun having kısmını eklemeye çalışınca hata alıyorum, sorun nerede olabilir ?
Sorgudaki hatalı kısım
Kod: Tümünü seç
(SELECT Y.* FROM YILIZINHARE Y
WHERE Y.SICIL =@SICIL
GROUP BY Y.SICIL
HAVING SUM(COALESCE(Y.HIZIN,0)) >= SUM(COALESCE(Y.IZIN,0))
Genel sorgu
Kod: Tümünü seç
--DECLARE @SICIL int
DECLARE @SICIL int=219
SELECT TOP 1 A.ID, COALESCE(A.IZIN, 0) AS IZIN, COALESCE(A.KAPAGUN,0) AS KULKAP,
(COALESCE(A.IZIN, 0)+ COALESCE(A.KAPAGUN,0)) AS SATKAPGUN,
(SELECT SUM(COALESCE(HIZIN, 0)) FROM YILIZINHARE B WHERE B.SICIL =@SICIL) AS TOPHAKEDIS,
(SELECT TOP 1 D.ID FROM YILIZINHARE D WHERE D.SICIL =@SICIL AND COALESCE(D.KAPAGUN,0) <> COALESCE(D.HIZIN, 0)) AS HID,
(SELECT TOP 1 C.YIL FROM YILIZINHARE C WHERE C.SICIL =@SICIL AND C.TIPGC='G'
AND COALESCE(C.KAPAGUN,0) <> COALESCE(C.HIZIN, 0) ORDER BY C.HAKEDIS ) AS YIL,
(SELECT TOP 1 COALESCE(D.HIZIN,0) FROM YILIZINHARE D WHERE D.SICIL =@SICIL AND D.TIPGC='G' ORDER BY D.HAKEDIS) AS SATIRHAKEDIS,
(SELECT TOP 1 (COALESCE(E.IZIN, 0)+COALESCE(E.KAPAGUN,0)) FROM YILIZINHARE E WHERE E.SICIL =@SICIL AND E.TIPGC='G' ORDER BY E.HAKEDIS) AS TAHKAP,
(SELECT TOP 1 CASE
WHEN SUM(COALESCE(F.HIZIN,0)) >= SUM(COALESCE(F.IZIN,0)) THEN SUM(COALESCE(F.IZIN,0))
WHEN SUM(COALESCE(F.HIZIN,0)) <= SUM(COALESCE(F.IZIN,0)) THEN SUM(COALESCE(F.IZIN,0))
ELSE SUM(COALESCE(F.HIZIN,0))- SUM(COALESCE(F.IZIN,0)) END AS KAPAMA FROM YILIZINHARE F
WHERE F.SICIL =@SICIL
AND
(SELECT TOP 1 CASE
WHEN SUM(COALESCE(F.HIZIN,0)) >= SUM(COALESCE(F.IZIN,0)) THEN SUM(COALESCE(F.IZIN,0))
WHEN SUM(COALESCE(F.HIZIN,0)) <= SUM(COALESCE(F.IZIN,0)) THEN SUM(COALESCE(F.IZIN,0))
ELSE SUM(COALESCE(F.HIZIN,0))- SUM(COALESCE(F.IZIN,0)) END AS KAPAMA FROM YILIZINHARE F
WHERE F.SICIL =@SICIL) <>
(SELECT TOP 1 COALESCE(D.HIZIN,0) FROM YILIZINHARE D WHERE D.SICIL =@SICIL AND D.TIPGC='G' ORDER BY D.HAKEDIS)
) AS TOPKULL
FROM YILIZINHARE A
WHERE A.SICIL =@SICIL AND A.TIPGC='C'
AND A.KOD=1
AND 1=1
AND (SELECT G.* FROM YILIZINHARE G
WHERE G.SICIL =@SICIL
GROUP BY G.SICIL
HAVING SUM(COALESCE(G.HIZIN,0)) >= SUM(COALESCE(G.IZIN,0)))
ORDER BY A.HAKEDIS