Hi.<BR><BR>I am using DAO in ASP to connect to a SQL Server database. All is well until I need to loop through 100 records, and for each record I need to query another table and sort by the date. For some reason the "Order by" in my SQL statement causes SQL Server to take a ridiculous amount of time, causing my pages to time out. If I remove the "Order by", all is fine! Any ideas?