>Hi everybody,
>
>Just curious for SQL Server 2000 how would you get LIMIT functionality. It's not hard to write for SQL Server 2005 and up.
How about:
SET ROWCOUNT 5
SELECT * FROM YourTable WHERE Something >= 10
SET ROWCOUNT 0
That should returns 5 rows.
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.