Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 Dynamic TOP-Clause

Author  Topic 

cecilius
Starting Member

19 Posts

Posted - 2002-08-10 : 11:34:30
Hi there,
i have to pass a variable to a stored procedure (no problem) wich should be used with the TOP-Clause.

e.g. Variable is 16, sql should be: select TOP 16 * from...

is there any way to get this working?
thx a lot an d best regards

Merkin
Funky Drop Bear Fearing SQL Dude!

4970 Posts

Posted - 2002-08-10 : 11:38:12
Hi

This is a good question..
So good, it gets asked a lot
So often...it made it in here http://www.sqlteam.com/FAQ.asp



That should do it, good luck

Damian
Go to Top of Page
   

- Advertisement -