J
JIM.H.
Hello,
I am suing the following query to select top 1000 and it seems very slow.
SELECT T1.pID, T1.location, T1.lSvc INTO tTop
FROM tAge AS T1
WHERE (((T1.pID) In (SELECT Top 1000 T2.pID FROM tAge as T2 WHERE
T2.loc=T1.loc ORDER BY T2.lSvc Desc, T2.pID Desc)));
Is there any way I can speed this up or use another way to find top 1000
records?
Thanks,
I am suing the following query to select top 1000 and it seems very slow.
SELECT T1.pID, T1.location, T1.lSvc INTO tTop
FROM tAge AS T1
WHERE (((T1.pID) In (SELECT Top 1000 T2.pID FROM tAge as T2 WHERE
T2.loc=T1.loc ORDER BY T2.lSvc Desc, T2.pID Desc)));
Is there any way I can speed this up or use another way to find top 1000
records?
Thanks,