FreeTDS Development Group

[Michael Peppler <mpeppler AT peppler.org>]

Winkless, Geoff writes:
 > > Maybe I didn't make myself clear. I don't want the top n records.
 > > 
 > > I need the n top with an offset. For example:
 > 
 > You could try
 > 
 > SELECT IDENTITY(INT, 1, 1) id, * 
 > INTO #temp
 > FROM blah
 > 
 > SELECT * FROM #temp WHERE id BETWEEN 10 AND 20

Indeed. That is the generic way to achieve this functionality, and
should be at least as fast as the cursor example that the original
poster used in his example.

Michael
-- 
Michael Peppler - Data Migrations Inc. - http://www.mbay.net/~mpeppler
mpeppler AT peppler.org - mpeppler AT mbay.net
International Sybase User Group - http://www.isug.com