CREATE VIEW PLAS_LIST_GIDER AS
SELECT ROW_NUMBER() OVER(PARTITION BY CC.MANG ORDER BY CC.PLAS)AS SIRA,CC.PLAS,CC.MANG FROM (
SELECT          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
						 GROUP BY  CASE WHEN CM.MANG IS NULL THEN CM2.MANG ELSE CM.MANG END ,CASE WHEN CM.PLAS IS NULL THEN CM2.PLAS ELSE CM.PLAS END )CC