okay here's issue. the user can go onto site , retrieve 8 records @ time, he/she given option load more. these 8 records can sorted param passed proc. when these 8 records on front end, have id's (hidden user though obviously), id's not in specific order because records sorted variety of possible things. when click "load more", should able next 8 records database, sorted in same fashion first 8 were. for example, "give me top 8 records sorted age". -> click load more -> give me next 8 oldest records without showing me onces saw. how can call proc , make sure none first result set returned though? want return 8 records @ time efficiency reasons. select top 8 m.message, m.votes, (geography::point(@latitude, @longitude, 4326).stdistance(m.point)) * 0.000621371192237334 distance, m.location, datediff(hour,m.timestamp, getdate()) age, m.messageid, ml.voted, ml.flagged tblmessages m ...