somewhere around 300-400 .... but the rows are the result of a querry with some heavy calculations , not just a simple querry. The user has to wait already for...

i had to write DB application to work with sqlserver, and its 75% complete.

all my pk's are guids. im just a noob in this, and i didnt used result paging...

unfortunately i dont have sqlserver installed here, and i cant test it until tomorrow , but because the GUID is not incremental, and not generated in a certaing order (like...

because im trying to limit the number of results the user gets , TOP wont be enough because i need to generate lets say the next 20 results ....

thank you for the post, but the problem is that if i raiserror smaller then 16 , i dont get any error (just an informative message), if i make...

thank you, you've been a great help