Fetch Top N Rows

Hi ,

I have a Stored Procedure ,which Fetches Top 10 Rows .


But now i want to modify this Stored Procedure like Top N rows (
N
will be input parameter for the Stored Procedure)

So What is the Syntax to write like that .Please let me know the
Steps with an Example

Your Reply will be very much appreciated....


Thanks
Padmakar

Place you full result set into a temp table and then run a simple single recursive SQL statement starting with the first row of the above table and adding one row at a time and terminating this process when N rows have been extracted