Select Top X in Stored Procedure 1

[ISPrincess]

Is there some way to pass in the number of records to return to a stored procedure and then use that variable to return TOP X from table?
ie:

@iHowmanyrecs integer
as
Select Top @iHowManyRecs from MyTable

or will I need to build a dynamic SQL string and then exec it?


PH
I was walking home one night and a guy hammering on a roof called me a paranoid little weirdo.
In morse code.
-Emo Phillips

 

[vongrunt]

You can use SET ROWCOUNT temporarily:

set rowcount @iHowmanyrecs 
select blah blah from blah blah
set rowcount 0

 

[ISPrincess]

Thanks. i appreciate your quick response. I think, once again, I over-thought the issue!


PH
I was walking home one night and a guy hammering on a roof called me a paranoid little weirdo.
In morse code.
-Emo Phillips