Trouble using TOP operator

[Guest_imported]

I am trying to do a query that involves a select with a top clause and i don't know how to receive the top parameter as a stored procedure parameter. It is, i am receiving the parameter as @n but when i do the

select top @n * from table

this is not accepted by the interpreter. Thanks for help me.

 

[foxdev]

Try this:

[tt]exec ('select top ' + @n + ' * from mytable order by mycol')[/tt]

Ensure that @n is declared as char or varchar to use this syntax, or use CONVERT to convert an integer.

Robert Bradley

http://www.foxdev.com/