CREATE VIEW dbo.PLAS_SEHIR_SIRALI AS
SELECT        LOGICALREF, ROW_NUMBER() OVER (PARTITION BY CASE WHEN CM.PLAS IS NULL THEN CM2.PLAS ELSE CM.PLAS 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,QQ.CITY
FROM            (SELECT DISTINCT LOGICALREF,CITY
                          FROM            dbo.PLAS_RAPOR_AYLIK_SEHIR_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