SqlServer2005使用top 100 PERCENT 无法排序的问题

由于公司提供的分页控件需要我使用top子句，而且有必要将查询到的记录全部取出，确发现不能排序，sql语句如下：

 

SELECT TOP 15 * FROM(

SELECT TOP (100) PERCENT * FROM (

SELECT

a.recID, a.eventLevel, a.srcIP, a.dstIP, a.eventTime, a.eventCount, a.srcPort, a.dstPort,
b.popular, b.eventName, b.popularName, b.securityID, d.deviceIP, d.deviceName
FROM NETIDS_EVENTLOG a, NETIDS_DEFINE_EVENTBASE b, SYSTEM_DEPLOY d
WHERE a.eventTypeID=b.eventTypeID AND a.DEV_GUID=d.DEV_GUID

 

UNION ALL

 

SELECT 

a.recID, a.eventLevel, a.srcIP, a.dstIP, a.eventTime, a.eventCount, a.srcPort, a.dstPort,
b.popular, b.eventName, b.popularName, b.securityID, d.device