Can't you have a variable TOP in a select statement?

microsoft.public.sqlserver.programming

11 Nov 2005 8:15 AM

Morten Wennevik

Hi,

I got a stored procedure like this

CREATE PROCEDURE dbo.readImport
(
@Start INTEGER,
@Number INTEGER
)

AS

SELECT TOP @Number * FROM Import WHERE RowID >= @Start ORDER BY RowID
GO

However, it doesn't seem to like having an unknown @Number.
Any ideas?

Morten

11 Nov 2005 8:30 AM

Jens

Hi Morten,

If you are using SQL 2k its not possible.

The only thing is to use dynmiac sql for that.

HTH, Jens Suessmeyer.

11 Nov 2005 8:46 AM

Morten Wennevik

Ok, thanks

Morten

On Fri, 11 Nov 2005 09:30:25 +0100, Jens <J***@sqlserver2005.de> wrote:

Show quote

> Hi Morten,
>
> If you are using SQL 2k its not possible.
>
> The only thing is to use dynmiac sql for that.
>
> HTH, Jens Suessmeyer.
>
>

11 Nov 2005 11:23 AM

Tibor Karaszi

.... or SET @@ROWCOUNT...

--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/

Show quote

"Jens" <J***@sqlserver2005.de> wrote in message
news:1131697825.522144.101160@g49g2000cwa.googlegroups.com...
> Hi Morten,
>
> If you are using SQL 2k its not possible.
>
> The only thing is to use dynmiac sql for that.
>
> HTH, Jens Suessmeyer.
>