And it's gonna run much faster .

Why can't you just do a single insert statement??

Select SERVERPROPERTY('ProductLevel') AS SpLevel

Can we see the code? maybe there's a way to use a proc instead of dynamic sql.

No I mean a global SavedSearchResults table with something that identifies the search (UserID, SearchID, GUI, RowID). Then you can easily use that table to requery the next results...

Select...

Pretty much what I originally thaught (thanx for the dbcc command).

Let's say they still chose per user licensing, how are the 10 licenses managed...

How about caching the GUI into a results table (with identity or what method of generating it). Then query back from that tables and then generating the requested results?

How many rows are returned from a single search (normally)?

Split it into 3-4 parts.

then exec (@Select + @From + @Where + @OrderBy)

Ya it would... I had this working but the requirements were somewhat different. Depending on how long it takes to search and how many times the searches are hit,...

You can do it like this :

Select top 20 * from () dtSearh where GUI > @LastShownResult

Restore the file to another server and then you'll be able to query it. Check out BOLS for the syntax.

Why can't you handle that client side?

SELECT StoreName,SUM(NetSale * 1.0) AS sales

FROM Orders

I have no clue what you are talking about...

Can we have the tables definition, sample data and expected output please ?