Mikro programlarında, stokların son giriş fiyatlarını ana döviz ve orjinal döviz detayında veren sorgudur.

Sorgu:

 

 

SELECT TOP 100 PERCENT 
    s.sto_kod,
    s.sto_isim AS [İsmi],
    h.sth_miktar AS [Son Giriş Miktar],
    ISNULL(STH_NET_DEGER_ANA/sth_miktar,0.0) AS [Son Giriş Birim Fiyatı Ana],
    ISNULL(STH_NET_DEGER_ANA,0.0) AS [Son Giriş Tutarı Ana],
    ISNULL(STH_NET_DEGER_CARI_ORJ/sth_miktar,0.0) AS [Son Giriş Birim Fiyatı Orj],
    ISNULL(STH_NET_DEGER_CARI_ORJ,0.0) AS [Son Giriş Tutarı Orj],
    STH_HAR_DOVIZ_SEMBOLU AS [Son Giriş Döviz Cinsi]
FROM 
 (
    SELECT 
        sth_stok_kod,
        sth_Guid,
        ROW_NUMBER() OVER (PARTITION BY sth_stok_kod ORDER BY sth_tarih DESC, sth_create_date DESC) AS rn
    FROM STOK_HAREKETLERI WITH (NOLOCK)
    WHERE sth_evraktip IN (3, 13) AND sth_cins NOT IN (9, 15) AND sth_normal_iade=0
) C
INNER JOIN STOKLAR s ON s.sto_kod = C.sth_stok_kod
INNER JOIN STOK_HAREKETLERI_VIEW_WITH_INDEX_02 h ON h.sth_Guid = C.sth_Guid
WHERE rn = 1
ORDER BY C.sth_stok_kod