lol - ok, nicely done. Somewhat more efficient than cursors  Why don't you just build a table and then use a between? The following example is in T-SQL as it allows the handy table var (automatically cleared after sp exec) CREATE PROCEDURE getSubset (@start int, @end int) AS DECLARE @tblTemp TABLE (pID int, intData int, strData nvarchar(50)) INSERT INTO @tblTemp SELECT /*insert main functionality of sp here*/ SELECT * FROM @tblTemp WHERE pID between @start and @end ORDER BY intData Life's not difficult...enjoy it. Nood!e
|