CREATE VIEW dbo.MALZEMELER_SON_IKI_FIYAT
						 AS
						 SELECT        ITEMREF, REF, LINEEXP1, LINEEXP2, IHRSAT, IHRCURRENCY, SIRA,COMPANYREF
FROM            ((SELECT        ITEMREF, REF, LINEEXP1, LINEEXP2, IHRSAT, IHRCURRENCY, SIRA,COMPANYREF
                            FROM            ((SELECT        ITEMREF, REF, LINEEXP1, LINEEXP2, IHRSAT, IHRCURRENCY, ROW_NUMBER() OVER (PARTITION BY ITEMREF
                                                        ORDER BY CREATED_DATE DESC) AS SIRA,COMPANYREF
                            FROM            [IHR].[dbo].[PRCLIST])) QQ
WHERE        QQ.SIRA IN (1,2))) KK