Sessiz Mantık / Hesaplama Hataları

SELECT COUNT(*) FROM Cari.Islemler WHERE IsDeleted=0 AND (ISNULL(HasKur,0)=0 OR ISNULL(IscilikBirimKur,0)=0) AND IslemKodu=0; -- takoz işlemlerinde kur 0

SELECT type_desc FROM sys.objects WHERE object_id=OBJECT_ID('Sistem.TCMBDovizKurlari'); SELECT COUNT(*) FROM Sistem.NonUsed_TCMBDovizKurlari;

SELECT BirimId,Tarih,COUNT(*) FROM Sistem.Kurlar GROUP BY BirimId,Tarih HAVING COUNT(*)>1; SELECT Kodu,COUNT(*) FROM Sistem.Birimler WHERE IsDeleted=0 GROUP BY Kodu HAVING COUNT(*)>1; SELECT FisNo,COUNT(DISTINCT RefNo) FROM Cari.Islemler WHERE IsDeleted=0 GROUP BY FisNo HAVING COUNT(DISTINCT RefNo)>1;

SELECT Id,UserName FROM Sistem.Users WHERE Id=1; SELECT * FROM Sistem.UserDetails WHERE UserId NOT IN (SELECT Id FROM Sistem.Users);

SELECT COUNT(*) FROM Cari.IslemDetaylari D JOIN Cari.Islemler I ON I.Id=D.IslemId WHERE I.IsDeleted=1 AND ISNULL(D.ETTN,'')='' ;

SELECT OBJECT_ID('Pozisyon.GetOldPozisyon'); SELECT COUNT(*) FROM Sistem.NonUsed_TCMBDovizKurlari;

SELECT I.Id, I.Miktar*I.AuMilyem AS HasHesap, B.Bakiye FROM Cari.Islemler I JOIN Cari.BakiyeIslem B ON B.IslemId=I.Id AND B.BirimId=I.BakiyeId WHERE I.IsDeleted=0 AND I.IslemKodu IN (1,2,9) AND ABS(ABS(B.Bakiye)-ABS(I.Miktar*I.AuMilyem))>0.004; toplam sapma: SELECT SUM(ABS(B.Bakiye)-ABS(I.Miktar*I.AuMilyem)) ...

SELECT I.Id FROM Cari.Islemler I WHERE I.IsDeleted=0 AND I.IslemTipi NOT IN (1,11,12) AND I.IslemKodu IN (1,2,9,4,5,6) AND (I.Tutar<>0 OR (I.BakiyeId>0 AND I.Miktar<>0)) AND NOT EXISTS (SELECT 1 FROM Cari.BakiyeIslem B WHERE B.IslemId=I.Id); ayrıca sys.triggers sırasını ve SQL error log 3609 kayıtlarını inceleyin

SELECT COUNT(*), MAX(Tarih) FROM Cari.BakiyeDun; karşılaştırma: SELECT H.Id, FN.GetCariLimit(H.Id) AS KalanLimit, H.Limit + (-1)*(SELECT SUM(B.Bakiye*Brm.Carpan*K.Alis/KH.Alis) FROM Cari.BakiyeIslem B …) FROM Cari.HesapBilgileri H WHERE H.Limit<>0

SELECT HasSymbol FROM Sistem.Settings; SELECT * FROM Sistem.GetKurListesi(GETDATE()) WHERE Birim='HAS' OR Alis=0 OR Alis IS NULL; limit tanımlı hesaplarda çıkış işlemleri: SELECT I.Id,I.Satis,I.HasKur FROM Cari.Islemler I WHERE I.IsDeleted=0 AND I.IslemTuru=1 AND I.IslemTipi<>1 AND I.HasKur IN (0,1)

SELECT COUNT(*) FROM Cari.Islemler WHERE IsDeleted=0 AND (HasKur=1 OR GumKur=1 OR PltKur=1 OR PldKur=1 OR EurKur=1); SELECT s.HasSymbol,s.GumSymbol,s.PltSymbol,s.PldSymbol,s.UsdSymbol,s.EurSymbol FROM Sistem.Settings s; her biri için Sistem.Birimler'de IsDeleted=0 tek satır

SELECT B.Kodu FROM Sistem.Birimler B WHERE B.IsDeleted=0 AND B.IsComputed=0 AND NOT EXISTS (SELECT 1 FROM Sistem.Kurlar K WHERE K.BirimId=B.Id AND K.Tarih=CONVERT(date,GETDATE()) AND K.IsDeleted=0); SELECT * FROM Sistem.GetKurListesi(GETDATE()) WHERE Alis IS NULL OR Alis=0; SELECT Id,Kodu FROM Sistem.Birimler WHERE Id=1

SELECT BirimId,Tarih,COUNT(*) FROM Sistem.Kurlar WHERE IsDeleted=0 GROUP BY BirimId,Tarih HAVING COUNT(*)>1; SELECT * FROM Sistem.Kurlar WHERE Tarih>CONVERT(date,GETDATE()); SELECT Birim,COUNT(*) FROM Sistem.GetKurListesi(GETDATE()) GROUP BY Birim HAVING COUNT(*)>1

SELECT Id,Tarih,BirimId,Alis,Satis,LastModify FROM Sistem.Kurlar WHERE Id=1 – LastModify tarihinin Tarih'ten çok sonra olması bulguyu doğrular; SELECT * FROM Sistem.Kurlar WHERE LastModify > DATEADD(day,2,Tarih)

SELECT Tarih,BirimId,UserId,LastModify,InsertDate FROM Sistem.Kurlar WHERE Tarih=CONVERT(date,GETDATE()) AND UserId=0 – aynı gün UserId<>0 satırları yoksa ve LastModify öğleden sonra ise kopyalama sonradan yapılmış demektir

SELECT * FROM Sistem.Kurlar WHERE IsDeleted=0 AND (ISNULL(Alis,0)<=0 OR ISNULL(Satis,0)<=0); SELECT * FROM Sistem.GetKurListesi(GETDATE()) WHERE ISNULL(Alis,0)=0

SELECT K.BirimId,K.Alis, L.Alis FROM Sistem.Kurlar K JOIN Sistem.GetKurListesi(K.Tarih) L ON L.BirimId=K.BirimId WHERE K.Tarih=CONVERT(date,GETDATE()) AND K.Alis<>L.Alis

SELECT COUNT(*) FROM Cari.Islemler I WHERE I.IsDeleted=0 AND I.IslemTipi=12 AND I.IslemKodu IN (1,2,3); bunların hiçbirinde EXISTS(Stok.StokHaraketleri Bolum=0) olmamalı – varsa trigger sürümü farklıdır; History: SELECT TransactionId FROM Cari.History H WHERE LogType='Düzeltme' AND IslemTipi IN (11,12) AND EXISTS(SELECT 1 FROM Cari.History H0 WHERE H0.TransactionId=H.TransactionId AND H0.IslemTipi NOT IN (11,12))

SELECT Id,IslemKodu,IslemTuru,Miktar,Adet,Tutar FROM Cari.Islemler WHERE IsDeleted=0 AND (Miktar<0 OR Adet<0 OR Tutar<0); SELECT H.* FROM Stok.StokHaraketleri H JOIN Cari.Islemler I ON I.Id=H.IslemId AND H.Bolum=0 WHERE I.IslemKodu IN (1,2,9) AND H.StokTipi=1 AND SIGN(H.Miktar)<>CASE WHEN I.IslemTuru=0 THEN 1 ELSE -1 END

SELECT StokId,SubeId,KasaId,COUNT(*) FROM Stok.StokHaraketleri WHERE StokTipi=1 AND IslemTuru=0 GROUP BY StokId,SubeId,KasaId HAVING COUNT(*)>50; eldeki miktarı ilk 50 girişin toplamını aşan stoklar: karşılaştırma sorgusu; Bilanco.GetKurFarki çıktısı

SELECT StokId,SUM(Miktar) AS M5, SUM(CONVERT(decimal(18,2),Miktar)) AS M2 FROM Stok.StokHaraketleri WHERE StokTipi=1 GROUP BY StokId HAVING SUM(Miktar)<>SUM(CONVERT(decimal(18,2),Miktar))

SELECT I.Id,I.StokId,I.AuMilyem,M.Milyem,M.MilyemDurumu FROM Cari.Islemler I JOIN Stok.Maden M ON M.Id=I.StokId WHERE I.IsDeleted=0 AND I.IslemKodu IN (1,2) AND I.AuMilyem<>M.Milyem; SELECT StokId,SUM(Has) AS HasHareket, SUM(Miktar)*MAX(Milyem) FROM Stok.StokHaraketleri WHERE StokTipi=1 GROUP BY StokId

SELECT T.Id,T.Status,T.IsDeleted,COUNT(H.IslemId) FROM Cari.Transferler T LEFT JOIN Stok.StokHaraketleri H ON H.IslemId=T.Id AND H.Bolum=2 GROUP BY T.Id,T.Status,T.IsDeleted HAVING (T.Status=1 AND T.IsDeleted=0 AND COUNT(H.IslemId)<>2) OR ((T.Status<>1 OR T.IsDeleted=1) AND COUNT(H.IslemId)>0)

SELECT COUNT(*) FROM Stok.StokHaraketleri H JOIN Cari.Islemler I ON I.Id=H.IslemId WHERE H.Bolum<>0

SELECT H.* FROM Stok.StokHaraketleri H WHERE H.StokTipi=4 AND (H.Maliyet IS NULL OR H.Maliyet=0); SELECT I.Id,I.IslemTipi,I.BirimId FROM Cari.Islemler I WHERE I.IslemKodu=8 AND I.IslemTipi=1 AND I.IsDeleted=0

SELECT COUNT(*) FROM Cari.Islemler WHERE IsDeleted=0 AND IslemKodu IN (0,14) AND CONVERT(date,InsertDate)<>Tarih