CREATE VIEW dbo.PLAS_SIRALI
AS
SELECT        LOGICALREF, ROW_NUMBER() OVER (PARTITION BY CASE WHEN CM.MANG IS NULL THEN CM2.MANG ELSE CM.MANG END ORDER BY LOGICALREF) AS SIRA, CASE WHEN CM.MANG IS NULL THEN CM2.MANG ELSE CM.MANG END AS MANG, CASE WHEN CM.PLAS IS NULL THEN CM2.PLAS ELSE CM.PLAS END AS PLAS
FROM            (SELECT DISTINCT LOGICALREF
                          FROM            dbo.PLAS_RAPOR_AYLIK_TOPLAM
                          WHERE        LOGICALREF IS NOT NULL) QQ LEFT OUTER JOIN CITY_MANG AS CM ON CM.SALESMANREF=QQ.LOGICALREF LEFT OUTER JOIN CITY_MANG AS CM2 ON CM2.SALESVEBREF=QQ.LOGICALREF