select a.编号,b.详细信息 from a, (select 'view_'+a.类型 from a c where c.编号=a.编号') b where a.编号=b.编号
declare @s varchar(8000) set @s = ' 'select @s = ' union all select a.编号,b.详细信息 from a,view_'+类型+' where a.编号=b.编号 and a.类型 = '''+类型+'''' + @s from a group by 类型set @s = stuff(@s,1,11,'')exec(@s)
set @s = ' 'select @s = ' union all select a.编号,b.详细信息 from a,view_'+类型+' where a.编号=b.编号 and a.类型 = '''+类型+'''' + @s
from a group by 类型set @s = stuff(@s,1,11,'')exec(@s)