I have a search requirement from the client(Asp.net website), which is like i will search among thousends of employees. i will get the results,then i will search within the resultset again.How to do this in the best way.The simplest solution can be to search the whole database again just by adding criterias to the previous query.Another way that i thought of, is to insert the employee id's retrieved from the first query into a table along with a search id for every search and then do the second search based on the values in that table.Then continue like the same way,inserting the employee ids of the resultset in the table again and again.Does anyone have any better idea? :confused: