With cte as
(Select Деталь, КолВо From План Where Дата Between @ДатаНач and @ДатаКон
Union all
Select b.Деталь, b.КолВо * a.КолВо --Количество сборок в плане * на количество деталей в сборке
 From cte a
 join Сборки b on a.Деталь = b.Сборка
)
Select Деталь,Sum(КолВо) as ОбщееКоличество 
 From CTE a
Where not exists (Select 1 From Сборки b Where a.Деталь = b.Сборка)
Group by Деталь

With cte as
(Select Деталь, Дата, КолВо From План Where Дата Between @ДатаНач and @ДатаКон
Union all
Select b.Деталь, a.Дата, b.КолВо * a.КолВо --Количество сборок в плане * на количество деталей в сборке
 From cte a
 join Сборки b on a.Деталь = b.Сборка
)
Select Деталь,Дата,Sum(КолВо) as ОбщееКоличество 
 From CTE a
Where not exists (Select 1 From Сборки b Where a.Деталь = b.Сборка)
Group by Деталь,Дата

with T(dataz,spvx,kodizd,kodsb,kodvx, kol,lv) AS 
(SELECT p.dataz,spvx,s.kodizd,s.kodizd as kodsb,kodvx, sum(p.kol*s.kol), 
 1 AS lv 
 FROM plano p 
 join sostav s on s.kodizd=p.kodizd
 where p.dataz between '01-06-2018' and '30-06-2018'
 Group by dataz,spvx,s.kodizd, kodvx
	UNION ALL 
 SELECT t.dataz,s.spvx, s.kodizd,t.kodvx as kodsb,s.kodvx, s.kol*t.kol, 
	t.lv + 1 AS lv 
 FROM sostav s 
 inner join t on  s.kodizd = t.kodvx
) 
SELECT t.dataz,t.kodvx as Код, i1.izd as vxod,i2.izd ,sum(t.kol)
FROM T 
inner join izd i1 on i1.Код=t.kodvx 
inner join izd i2 on i2.Код=t.kodsb
where i1.izd='Краска'
Group by t.dataz,t.kodvx,i1.izd,i2.izd