Hi, I'm having problem with query large recordset from MSSQL2000. The situation is we have tables generated by Peoplesoft and we need a few reports that count number of employee and their salary from user's specified range of time (from date- to date) and organization level. After we call the SQL statement through ASP page, it takes ages to see the result and sometimes the page just disconnected. Please advise on how to manipulate large recordset or is there any way to increase query performance. (Does anyone work with Pepplesoft man power report before?) Thank you ka.