CREATE VIEW [dbo].[View_Malzeme_Siparis_Gecmisi]
AS
SELECT 
    S.STOCKREF AS REF,
    S.USERID,
    S.ORDERDATE,
    S.AMOUNT,
    M.*,
    ROW_NUMBER() OVER (
        PARTITION BY S.STOCKREF, S.USERID, S.ORDERDATE 
        ORDER BY M.CREATE_DATE
    ) AS rn
FROM [UNIVERSALDB].[dbo].[STOK_RAPOR_SEPET_TEKIL_SIPARISLAR] S
INNER JOIN [IHR].[dbo].[MALZEME_SIPARIS_GECMISI_HEPSI] M 
        ON S.STOCKREF = M.STOCKREF
WHERE M.CREATE_DATE >= S.ORDERDATE;