If you liked the first article, then read on; I received a number of very good follow up questions from Nick that you might find interesting. This article focuses on the performance of the solution I proposed in the first article, as well as the problems associated with returning a single randomly chosen row from a table.

-- Try this code to generate a random number---- Calculate seed value-- The seed is based on a GUID created by the NEWID function.--SELECT @seed = CONVERT(int, CONVERT(varbinary, REPLACE(CONVERT(varchar(50), NEWID()), '-', '')))

'Only show the next button if we are NOT on the last pageif Not bolLastPage then %> <INPUT TYPE=BUTTON VALUE="Next <%=iMaxRecords%> Records >>" ONCLICK="document.location.href='thispage.asp?page=<%=currentPage+1%>'"><% end if %></CENTER>