Well I need the @top parameter so when I call the procedure if the @top is not supplied to return all the rows, else return the @top rows so I don't know if a local variable would help.

Thank you