DECLARE @companyid TABLE ( [ Id ] [ int ] );

with cte as ( 

select Id from [ base ].[ Company ] where Id= 123 

union all 

select a.Id from [ base ].[ Company ] a,cte b where a.ParentId= b.Id )

INSERT @companyid(id) select Id from cte

1、with 前边的sql语句需加分号；

2、使用with变量需紧跟with语句；

3、with变量只能紧跟的使用一次；