SQL查询出A表中用逗号分隔的ID的详细数据
select * ,主管领导姓名=stuff((select ','+姓名 from B where charindex(','+convert(varchar,b.序号),','+a.主管领导)>0 for xml path('')),1,1,'') from A
select * ,主管领导姓名=stuff((select ','+姓名 from B where charindex(','+convert(varchar,b.序号),','+a.主管领导)>0 for xml path('')),1,1,'') from A