SELECT idd=identity(int,1,1),sName
into #t
FROM Menu WHERE iParentId IN (SELECT ID FROM Menu WHERE sName = 'highlight' AND iParentId IN (SELECT ID FROM Menu WHERE ID in ('2',' 146',' 163',' 216',' 147')))
order by sName select sName
from #t
where id=(select min(id) from #t where sName=a.sName)
order by iParentId
into #t
FROM Menu WHERE iParentId IN (SELECT ID FROM Menu WHERE sName = 'highlight' AND iParentId IN (SELECT ID FROM Menu WHERE ID in ('2',' 146',' 163',' 216',' 147')))
order by sName select sName
from #t
where id=(select min(id) from #t where sName=a.sName)
order by iParentId
into #t
FROM Menu WHERE iParentId IN (SELECT ID FROM Menu WHERE sName = 'highlight' AND iParentId IN (SELECT ID FROM Menu WHERE ID in ('2',' 146',' 163',' 216',' 147')))
order by sName select sName
from #t
where idd=(select min(idd) from #t where sName=a.sName)
order by iParentId
sName
FROM
Menu WHERE iParentId IN (SELECT ID FROM Menu WHERE sName = 'highlight' AND iParentId IN (SELECT ID FROM Menu WHERE ID in ('2',' 146',' 163',' 216',' 147')))
group by
sName
order by
min(ID)
SELECT idd=identity(int,1,1),sName,iParentId
into #t
FROM Menu WHERE iParentId IN (SELECT ID FROM Menu WHERE sName = 'highlight' AND iParentId IN (SELECT ID FROM Menu WHERE ID in ('2',' 146',' 163',' 216',' 147')))
order by sName select sName
from #t a
where idd=(select min(idd) from #t where sName=a.sName)
order by iParentId
一会再试一下 lsxaa(小李铅笔刀) 的!!!
谢谢!!