临时表，表变量

--临时表

create table #table (c varchar(50),n varchar(50),l int,p varchar(50),m varchar(50),s varchar(50),f varchar(50))
insert #table 
exec p_Comm_Area_GetDownListByCodeLevel '008644',2
 SELECT  count(a.TeamId) as CitySum,b.n
  FROM t_Team_TeamList  a
  inner join #table b on b.c = a.City
   group by b.n

--表变量，新建一个表当一个变量，可以增、删、改、查

ALTER PROC p_Team_City

@city varchar(50)
AS
DECLARE @A TABLE(c varchar(50),n varchar(50),l int,p varchar(50),m varchar(50),s varchar(50),f varchar(50))
insert @A 
exec p_Comm_Area_GetDownListByCodeLevel @city,2
 SELECT  count(a.TeamId) as CitySum,b.n
  FROM t_Team_TeamList  a
  inner join @A b on b.c = a.City
  group by b.n