CREATE VIEW dbo.STOK_RAPOR_SIPARISLER_TOPLAM_DEGER
AS
SELECT 
    SP.STOCKREF,
    STUFF(
        (SELECT ', ' + K.ISIM
         FROM UNIVERSALDB.dbo.STOK_RAPOR_SIPARIS_VERILDI AS SP2
         LEFT JOIN UNIVERSALDB.dbo.KULLANICILAR AS K ON K.REF = SP2.USERID
         WHERE SP2.STOCKREF = SP.STOCKREF
         FOR XML PATH(''), TYPE).value('.', 'NVARCHAR(MAX)'), 1, 2, '') AS KULLANICILAR,
    SUM(SP.AMOUNT) AS TOPLAM_SIPARIS
FROM 
    UNIVERSALDB.dbo.STOK_RAPOR_SIPARIS_VERILDI AS SP
LEFT JOIN 
    UNIVERSALDB.dbo.KULLANICILAR AS K ON K.REF = SP.USERID
GROUP BY 
    SP.STOCKREF