列装行后如何将结果放入一个表里

[kuxuan21]

请教大侠们一个问题，像列装行的写法
select Ltyp,stuff((select ','+Lname from #SQltemp b where a.Ltyp=b.Ltyp order by Lname for xml path('')),1,1,'')
from #SQltemp a
group by Ltyp



如何把得到的结果，如何存入另一个表里

[快溜]

 insert into 另表
  select Ltyp,
  stuff((select ','+Lname from #SQltemp b where a.Ltyp=b.Ltyp order by Lname for xml path('')),1,1,'') from #SQltemp a group by Ltyp

[AcHerat]

insert into tb
select Ltyp,stuff((select ','+Lname from #SQltemp b where a.Ltyp=b.Ltyp order by Lname for xml path('')),1,1,'')
from #SQltemp a
group by Ltyp

--or

select Ltyp,stuff((select ','+Lname from #SQltemp b where a.Ltyp=b.Ltyp order by Lname for xml path('')),1,1,'')
    into tb
from #SQltemp a
group by Ltyp

[AcHerat]

如果是into的话，注意select 后的第二个字段就是一大串表达式的那个字段一定要有名称！ stuff(...) as ... 然后存入表。
insert into 可以不用。

[gw6328]

关注楼主结贴率1