CREATE VIEW [dbo].[MALZEME_SIRALI_FIYAT]
AS
SELECT        *
FROM            ((SELECT        TOP (1000) [REF], [ITEMREF], [COMPANYREF], [PRICE], [CURRENCY],ISNULL([LINEEXP1],'') AS LINEEXP1,ISNULL([LINEEXP2],'') AS LINEEXP2,ISNULL([IHRSAT],0) AS IHRSAT,ISNULL([IHRCURRENCY],1) AS IHRCURRENCY, [ORDER_], ROW_NUMBER() OVER (PARTITION BY ITEMREF
                            ORDER BY [ORDER_] DESC) AS SIRA
FROM            [IHR].[dbo].[PRCLIST])) QQ
WHERE        QQ.SIRA = 1