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)