CREATE VIEW dbo.PLASIYER_TSI_TAHSILAT_TUR_TOPLAMLARI
AS
SELECT CASE WHEN QQ.PDEF='' THEN 'TANIMSIZ' ELSE QQ.PDEF END AS PDEF,
[TRCODE],[ISLEM],[YIL],[CITY],[TOPLAM]  
FROM
(SELECT ISNULL([PDEF], SPECODE2) AS PDEF
      ,[TRCODE]
      ,[ISLEM]
      ,[YIL]
	  ,[CITY]
      ,SUM([TRNET]) AS TOPLAM
  FROM [UNIVERSALDB].[dbo].[PLASIYER_TSI_LISTESI]
  WHERE TRCODE NOT IN (33,38)
  GROUP BY 
  [PDEF]
 ,[TRCODE]
 ,[ISLEM]
 ,[YIL],SPECODE2,[CITY]) QQ