; with cte As (select aec00000.planid,abe00000.*,cast(abe00000.num as numeric(18,4)) As CalcNum from abe00000 join aec00000 on abe00000.parentitem = aec00000.itemcode join eba00000 on aec00000.id_contract = eba00000.id_contract where aec00000.planid =\'0000104442\' union all select cte.planid,a.*,cast(a.num * cte.CalcNum as numeric(18,4))from abe00000 a Join cte on a.parentitem  = cte.childitem) select a.planid,d.requiredate,a.parentitem,a.childitem,a.CalcNum*d.plannum as totalnum from cte a,aec00000 d where a.planid=d.planid union all Select planid,requiredate,itemcode As parentitem,itemcode As childitem,plannum As totalnum from aec00000 where planid  =\'0000104442\'

这段递归语句是正确的，现在希望将上述的查询结果添加到后台sql数据库的"表A"中，请教如何写代码，试了很多次，总是不成功，假设数据源为ERP

用上面的语句生成查询表，然后逐行读取，逐行写入后台的表

为什么直接用insert into 不可以呢

说到Insert into ，这个你比我在行啊