Thanks Steve. Great article. I have a question the might be slightly off topic. What would be the best way in sql server 2000 to write a stored proc that takes the row limit as an argument?

CREATE PROCEDURE MyTestProc

@rowlimit

AS

??????

-Kevin Williams