CREATE VIEW dbo.STOK_KONTROL_VIEW
AS
SELECT   [ITEMREF], [STOCK], [COUNTING], [SECIM], ROW_NUMBER() OVER (PARTITION BY ITEMREF ORDER BY DATE_ DESC) AS ORDER_
FROM         dbo.STOK_KONTROL