with tab2 (num,brand,City,Counts,Share,sum2012)
as(
select  
     
	
	 case when isnull(brandName,'Others') ='Others' then 3
	      else 1
	      end as num,
	 isnull(brandName,'Others') as 'brand',
      Name_City,
      sum(counts) as [Counts] , 
      Sum(Share) as [Share],
      dbo.MISPSumAllCity(@YearRep) as 'sum2012' 
      
   
    from dbo.MISCites(@YearRep)
    left outer join [Sales].[dbo].[Mis_top10_brands] on brandName=brand 
   
   group by  
   isnull(brandName,'Others'),
   Name_City
   )


 select * from tab2