ALTER procedure [UI]
  @Item     int,
  @Status   INT,
  @Id INT
as
begin
  set nocount on
  --SET ARITHABORT ON
 
  SELECT distinct /* Actor as [ID] */C2.ID, C2.Firm AS NAME,/* C1.Name, */ C3.Name AS VidID, C4.Name AS SubVid, City AS Region, Approval = CASE C2.Approval WHEN 4 THEN 'Аккредитован' WHEN 5 THEN 'Отклонен' WHEN 6 THEN 'В черном списке' end, C1.Status,  /* C2.Approval, */ C2.DateRegLegal,
  C3.Name AS ActivityName, C4.Name AS SubActivityName
  into #Temp
  from dbo.Actors C1, ContractFull C2, DictContractActivity C3, DictContractSubsActivity C4
  where ItemID = @Item AND  C2.VidID = C3.VidID and C3.VidID = C4.PodVid AND C2.SubVid = C4.ID AND C1.Status > @Status --AND C2.ID = 11355000 --AND Approval IN (4,5,6) 
  --SELECT * FROM #Temp 
                                                                                             
  SELECT SubActivity 
	into #SubActivityID
	from ContractFullSubActivity 
	where ContractID = @id
	
	
	SELECT  Name
	into #subTemp
	from DictContractSubsActivity d
		inner join #SubActivityID d1 on d.ID = d1.SubActivity
	where podvid = (select VidID from #temp)
	
	
	SELECT
	 stuff
	 (
	  (
	   SELECT TOP 1 t2.Name+','
	   from #subTemp t2
	   
	   for xml path('')
	  ,type
	  ).value('.','varchar(max)'),
	  1,0,''
	 ) as Name1
	into #sub
	from #subTemp t1
	
	
	update #temp
	set SubVid = name1
	
	SELECT * from #temp
	                                                                                          
END

--where podvid = (select VidID from #temp)
	where podvid in (select VidID from #temp)