mssql 2005中top新用法

with lib as
(
select type='s',showcount=2 union all
select type='v',showcount=1 union all
select type='p',showcount=3 
)
select 
lib.*,o.* 
from 
lib 
cross apply
(select top(lib.showcount)name,create_date
from
  sys.objects
order by
  create_date
)o
  order by lib.type,o.create_date
来自:http://52mvc.com/showtopic-572.aspx