BU HATA NASIL ÇÖZULUR

Islem Tamamlanamadi !...
Islem Tamamlanamadi...!
Hata: Puantaj Update

SQL : Update Puantaj Set Tutar=DBO.tutarhesapla(isyeri,sicilno,yil,ay,ayici,tip,sira_no,0,1,Deger,'H',2,'H') WHERE isyeri='AKUGUR' AND SICILNO IN(SELECT DISTINCT SICILNO FROM SICILAY WHERE ISYERI=PUANTAJ.ISYERI AND YIL = PUANTAJ.YIL AND AY = PUANTAJ.AY AND AYICI = 0 AND NETTENGIT = 'E' AND NETI <> 0) AND TIP IN (SELECT TIP FROM HESAPDET WHERE ISYERI=PUANTAJ.ISYERI AND SICILNO=PUANTAJ.SICILNO AND HESAPKODU=(SELECT HESAPKODU FROM SICILAY WHERE ISYERI=PUANTAJ.ISYERI AND SICILNO=PUANTAJ.SICILNO AND YIL=PUANTAJ.YIL AND AY=PUANTAJ.AY AND AYICI=0) AND YIL=PUANTAJ.YIL AND AY=PUANTAJ.AY AND AYICI=0) AND SIRA_NO IN(SELECT SIRA_NO FROM HESAPDET WHERE ISYERI=PUANTAJ.ISYERI AND SICILNO=PUANTAJ.SICILNO AND HESAPKODU=(SELECT HESAPKODU FROM SICILAY WHERE ISYERI=PUANTAJ.ISYERI AND SICILNO=PUANTAJ.SICILNO AND YIL=PUANTAJ.YIL AND AY=PUANTAJ.AY AND AYICI=0) AND YIL=PUANTAJ.YIL AND AY=PUANTAJ.AY AND AYICI=0 AND TIP=PUANTAJ.TIP) AND YIL=2011 AND AY=3 AND AYICI=0

The conversion from