Düzenle: UNI_USD_FIYAT

İlgili Uygulama

Nesne Türü

Nesne Adı

Bu nesne dönem devrinden etkileniyor mu? (Örn: İçinde _01_ gibi sabit dönem kodu var mı?)

Genel Kullanım Amacı ve Notlar

Tam SQL Kodu

CREATE VIEW dbo.UNI_USD_FIYAT
AS
SELECT        CARDREF, PRICE / CASE WHEN (CASE WHEN CURRENCY <> 1 THEN
                             (SELECT        TOP (1) [RATES1]
                               FROM            [UNIVERSALDB].[dbo].[L_DAILYEXCHANGES]
                               WHERE        CRTYPE = 1
                               ORDER BY EDATE DESC) ELSE 1 END) = 0 THEN 1 ELSE (CASE WHEN CURRENCY <> 1 THEN
                             (SELECT        TOP (1) [RATES1]
                               FROM            [UNIVERSALDB].[dbo].[L_DAILYEXCHANGES]
                               WHERE        CRTYPE = 1
                               ORDER BY EDATE DESC) ELSE 1 END) END AS USD, 300 /
                             (SELECT        TOP (1) RATES1
                               FROM            dbo.L_DAILYEXCHANGES
                               WHERE        (CRTYPE = 1)
                               ORDER BY EDATE DESC) AS USD300, 500 /
                             (SELECT        TOP (1) RATES1
                               FROM            dbo.L_DAILYEXCHANGES AS L_DAILYEXCHANGES_2
                               WHERE        (CRTYPE = 1)
                               ORDER BY EDATE DESC) AS USD500, 1000 /
                             (SELECT        TOP (1) RATES1
                               FROM            dbo.L_DAILYEXCHANGES AS L_DAILYEXCHANGES_1
                               WHERE        (CRTYPE = 1)
                               ORDER BY EDATE DESC) AS USD1000, 1750 /
                             (SELECT        TOP (1) RATES1
                               FROM            dbo.L_DAILYEXCHANGES AS L_DAILYEXCHANGES_1
                               WHERE        (CRTYPE = 1)
                               ORDER BY EDATE DESC) AS USD1750
FROM            dbo.LG_011_PRCLIST
WHERE        (PTYPE = 2)

Oluşturulma: 23.12.2025 07:15 Son Güncelleme: 23.12.2025 17:28

İptal Nesneyi Sil