Matthew Friedman wrote:
> is there a limit function ins SQL Server 2000?
No/yes. Look up TOP, but in order to create an offset you need to use it
twice. Pseudo SQL:
SELECT TOP 15 *
FROM (
SELECT TOP 15015 *
FROM table1
ORDER BY id DESC
) table2
ORDER BY id ASC
Jochem
______________________________________________________________________
Your ad could be here. Monies from ads go to support these lists and provide more
resources for the community. http://www.fusionauthority.com/ads.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
