CREATE VIEW dbo.STOK_RAPOR_SEPET_TEKIL_SIPARISLAR
AS
SELECT 
    ROW_NUMBER() OVER(PARTITION BY STOCKREF, USERID ORDER BY ORDERDATE DESC) AS RowNum,
    STOCKREF, 
    USERID, 
    ORDERDATE, 
    SUM(
        CAST(
            REPLACE(
                REPLACE(
                    REPLACE(
                        REPLACE(
                            REPLACE(
                                REPLACE(
                                    REPLACE(
                                        REPLACE(
                                            REPLACE(AMOUNT, '?', ''), 
                                            'BEKLEMEDE', ''
                                        ), 
                                        'ARIZALI', ''
                                    ), 
                                    'YANLIS', ''
                                ), 
                                'ÜRÜN DOGRU', ''
                            ), 
                            'KONTROL EDILECEK', ''
                        ), 
                        'ÜRETIM HATASI', ''
                    ), 
                    'UYUMSUZ', ''
                ), 
                'dikkat', ''
            ) AS int
        )
    ) AS AMOUNT
FROM dbo.STOK_RAPOR_SIPARISLER
WHERE 
    DEL_ = 0 
    AND ORDERDATE IS NOT NULL 
    AND ORDERDATE <> '' 
    AND STOCKREF IS NOT NULL 
    AND STOCKREF <> 0
GROUP BY STOCKREF, USERID, ORDERDATE