< DOCTYPE html PUBLIC -WCDTD XHTML StrictEN httpwwwworgTRxhtmlDTDxhtml-strictdtd>
declare @sql as nvarchar(max),@sql1 as nvarchar(max),@sql2 as nvarchar(max),@i as int,@j as int,@l as int,@tmp as nvarchar(max),@stri as nvarchar(5)
set @sql1='';
set @i=0
set @l=3
set @sql2=''
while(@i<@l)
begin
set @stri=cast(@i as nvarchar(5))
set @sql='declare @max'+@stri+' as table(id bigint,parentid int);
insert into @max'+@stri+'(id,parentid)
select max(id),parentid
from Products inner join Classes on Classes.classid=Products.classid
where parentid>0 '
set @j=0
set @tmp=''
while(@j<@i)
begin
set @tmp=@tmp+' and id not in(select id from @max'+cast(@j as nvarchar(5))+')'
set @j=@j+1
end
set @sql=@sql+@tmp+' group by ParentID;'
set @sql1=@sql1+@sql;
if(@i>0) set @sql2=@sql2+' union '
set @sql2=@sql2+'select * from @max'+@stri+' '
set @i=@i+1
end
set @sql=@sql1+
'select ProductName,ProductDpic,1 as indexID,Products.ID,UserName,RealName,Products.Addtime,ParentID from
Products inner join Admin_User on Admin_User.id=Products.userid inner join ('
exec sp_executesql @sql
<a href="http://enetcorner.blog.163.com/tag/%E6%95%B0%E6%8D%AE%E5%BA%93%E6%8A%80%E6%9C%AF/feeds">#資料庫技術</a>
<a href="http://home.cnblogs.com/u/netcorner/">netcorner</a>
<a href="http://home.cnblogs.com/u/netcorner/followees">關注 - 2</a>
<a href="http://home.cnblogs.com/u/netcorner/followers">粉絲 - 29</a>
<a>+加關注</a>
<a></a>
<a href="http://www.ucancode.com/index.htm" target="_blank">【推薦】超50萬VC++源碼: 大型組态工控、電力仿真CAD與GIS源碼庫!</a>
<a href="http://click.aliyun.com/m/43774/" target="_blank">【緬懷】傳奇謝幕,回顧霍金76載傳奇人生</a>
<a href="http://arction.cn/" target="_blank">【推薦】業界最快速.NET資料可視化圖表元件</a>
<a href="https://buy.cloud.tencent.com/domain?fromSource=gwzcw.882687.882687.882687" target="_blank">【騰訊雲】買域名送解析+SSL證書+建站</a>
<a href="https://www.yunqi2050.com/#/index" target="_blank">【活動】2050 科技公益大會 - 年青人因科技而團聚</a>
<b>最新IT新聞</b>:
<b>最新知識庫文章</b>:
本文轉自 netcorner 部落格園部落格,原文連結:http://www.cnblogs.com/netcorner/archive/2011/04/03/2911964.html ,如需轉載請自行聯系原作者