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)