Aşağıdaki sorgu managmentta çalışıyor yanlız, ado query veya ado prosedure içinde delphide çalışmıyor dbgride yansırken kolon başlıkları da siliniyor.
Çözm olarak ne yapmalıyım ?
Şimdiden teşekürler.
Kod: Tümünü seç
SELECT TOP 1 A.ID, COALESCE(A.IZIN, 0) AS IZIN, COALESCE(A.KAPAGUN,0) AS KAPAGUN,
(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 SATHGUN,
(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 A.KAPAMA='H' AND COALESCE(A.KAPAGUN,0) <> COALESCE(A.IZIN, 0)
ORDER BY A.HAKEDIS