Genel Bilgiler

SQL Server
View
✅ Etkilenmez
23.12.2025 07:15
23.12.2025 16:10

Notlar

Düzenle

Henüz not eklenmemiş.

+ Not ekle

İstatistikler

0
Kod Analizi
46
Satır
0
Kullandığı
53
Kullanan

→ Kullandığı Nesneler (0)

Bağımlılık bulunamadı

← Kullanan Nesneler (53)

👁️ B2B_PRODUCT_LIST
USES_VIEW
👁️ GENIS_MALZEME_BILGILERI
USES_VIEW
👁️ MALZEMELER
USES_VIEW
👁️ WEBAPI_ACX112233F
USES_VIEW
👁️ WEBAPI_ACY340403I
USES_VIEW
👁️ WEBAPI_ANS160146B
USES_VIEW
👁️ WEBAPI_Ayd420188i
USES_VIEW
👁️ WEBAPI_AYD420188K
USES_VIEW
👁️ WEBAPI_AYD420188K0
USES_VIEW
👁️ WEBAPI_BKM060355A
USES_VIEW
👁️ WEBAPI_BYD160167B
USES_VIEW
👁️ WEBAPI_BYI340214
USES_VIEW
👁️ WEBAPI_BYI340214I
USES_VIEW
👁️ WEBAPI_BYI340214I0
USES_VIEW
👁️ WEBAPI_BYZ010233A
USES_VIEW
👁️ WEBAPI_DEMO
USES_VIEW
👁️ WEBAPI_DGN630026S
USES_VIEW
👁️ WEBAPI_DGR210404I
USES_VIEW
👁️ WEBAPI_DGR210404I0
USES_VIEW
👁️ WEBAPI_DPR210241D
USES_VIEW
👁️ WEBAPI_ECD210408D
USES_VIEW
👁️ WEBAPI_EDG210281D
USES_VIEW
👁️ WEBAPI_Ege350342i
USES_VIEW
👁️ WEBAPI_GMS350327I
USES_VIEW
👁️ WEBAPI_GMS350327I0
USES_VIEW
👁️ WEBAPI_GNL410148K
USES_VIEW
👁️ WEBAPI_HLL270138G
USES_VIEW
👁️ WEBAPI_HLL270138GA
USES_VIEW
👁️ WEBAPI_HSA340686I
USES_VIEW
👁️ WEBAPI_HYM5400060S
USES_VIEW
👁️ WEBAPI_HYM540006S
USES_VIEW
👁️ WEBAPI_KGN340644I
USES_VIEW
👁️ WEBAPI_MGS340652I
USES_VIEW
👁️ WEBAPI_MRK460149K
USES_VIEW
👁️ WEBAPI_NUR340233K
USES_VIEW
👁️ WEBAPI_NVP500004N
USES_VIEW
👁️ WEBAPI_PAR3503120L
USES_VIEW
👁️ WEBAPI_PRT340364I
USES_VIEW
👁️ WEBAPI_RCD160158B
USES_VIEW
👁️ WEBAPI_RCP210275D
USES_VIEW
👁️ WEBAPI_SEN160130B
USES_VIEW
👁️ WEBAPI_SEN160130M
USES_VIEW
👁️ WEBAPI_SEN160130M_MIN
USES_VIEW
👁️ WEBAPI_SER3503120L
USES_VIEW
👁️ WEBAPI_Ser350312ii
USES_VIEW
👁️ WEBAPI_SER350312L
USES_VIEW
👁️ WEBAPI_SER350312P
USES_VIEW
👁️ WEBAPI_SIN340479I
USES_VIEW
👁️ WEBAPI_SOY350194I
USES_VIEW
👁️ WEBAPI_SYR340164I
USES_VIEW
👁️ WEBAPI_TMP340226i
USES_VIEW
👁️ WEBAPI_TNY240001E
USES_VIEW
👁️ WEBAPI_TRS330406M
USES_VIEW

→ Bağımlılık Ağacı

Bağımlılık bulunamadı

← Etki Ağacı

Tam SQL Kodu

Düzenle 
CREATE VIEW dbo.UNI_TL_FIYAT
AS
SELECT        CARDREF, CASE WHEN PRICE * (CASE WHEN CURRENCY = 1 THEN
                             (SELECT        TOP (1) [RATES1]
                               FROM            [UNIVERSALDB].[dbo].[L_DAILYEXCHANGES]
                               WHERE        CRTYPE = 1
                               ORDER BY EDATE DESC) ELSE 1 END) BETWEEN 200 AND 201 THEN 200 WHEN PRICE * (CASE WHEN CURRENCY = 1 THEN
                             (SELECT        TOP (1) [RATES1]
                               FROM            [UNIVERSALDB].[dbo].[L_DAILYEXCHANGES]
                               WHERE        CRTYPE = 1
                               ORDER BY EDATE DESC) ELSE 1 END) BETWEEN 500 AND 501 THEN 500 WHEN PRICE * (CASE WHEN CURRENCY = 1 THEN
                             (SELECT        TOP (1) [RATES1]
                               FROM            [UNIVERSALDB].[dbo].[L_DAILYEXCHANGES]
                               WHERE        CRTYPE = 1
                               ORDER BY EDATE DESC) ELSE 1 END) BETWEEN 1000 AND 1001 THEN 1000 WHEN PRICE * (CASE WHEN CURRENCY = 1 THEN
                             (SELECT        TOP (1) [RATES1]
                               FROM            [UNIVERSALDB].[dbo].[L_DAILYEXCHANGES]
                               WHERE        CRTYPE = 1
                               ORDER BY EDATE DESC) ELSE 1 END) BETWEEN 2000 AND 2001 THEN 2000 WHEN PRICE * (CASE WHEN CURRENCY = 1 THEN
                             (SELECT        TOP (1) [RATES1]
                               FROM            [UNIVERSALDB].[dbo].[L_DAILYEXCHANGES]
                               WHERE        CRTYPE = 1
                               ORDER BY EDATE DESC) ELSE 1 END) BETWEEN 2500 AND 2501 THEN 2500 WHEN PRICE * (CASE WHEN CURRENCY = 1 THEN
                             (SELECT        TOP (1) [RATES1]
                               FROM            [UNIVERSALDB].[dbo].[L_DAILYEXCHANGES]
                               WHERE        CRTYPE = 1
                               ORDER BY EDATE DESC) ELSE 1 END) BETWEEN 4000 AND 4001 THEN 4000 WHEN PRICE * (CASE WHEN CURRENCY = 1 THEN
                             (SELECT        TOP (1) [RATES1]
                               FROM            [UNIVERSALDB].[dbo].[L_DAILYEXCHANGES]
                               WHERE        CRTYPE = 1
                               ORDER BY EDATE DESC) ELSE 1 END) BETWEEN 7000 AND 7001 THEN 7000 WHEN PRICE * (CASE WHEN CURRENCY = 1 THEN
                             (SELECT        TOP (1) [RATES1]
                               FROM            [UNIVERSALDB].[dbo].[L_DAILYEXCHANGES]
                               WHERE        CRTYPE = 1
                               ORDER BY EDATE DESC) ELSE 1 END) BETWEEN 10000 AND 10001 THEN 10000 WHEN PRICE * (CASE WHEN CURRENCY = 1 THEN
                             (SELECT        TOP (1) [RATES1]
                               FROM            [UNIVERSALDB].[dbo].[L_DAILYEXCHANGES]
                               WHERE        CRTYPE = 1
                               ORDER BY EDATE DESC) ELSE 1 END) BETWEEN 20000 AND 20001 THEN 20000 ELSE PRICE * (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 TL
FROM            dbo.LG_011_PRCLIST
WHERE        (PTYPE = 2)

Kodun Çalışma Mantığı (Adım Adım)

Analiz Ekle/Düzenle

Henüz bu nesne için bir analiz girilmemiş.

İlk Analizi Ekle