这条SQL语句有错误吗？

[weddingin2008]

create proc max_speed
@table nvarchar(20),
@currentpage int,
@pagesize int,
@orderby nvarchar(20)
as
SELECT TOP @pagesize *
FROM @table
WHERE (@orderby NOT IN
(SELECT TOP @pagesize*@currentpage id
FROM @table
ORDER BY @orderby))
ORDER BY @orderby


Server: Msg 170, Level 15, State 1, Procedure max_speed, Line 7
Line 7: Incorrect syntax near '@pagesize'.
Server: Msg 170, Level 15, State 1, Procedure max_speed, Line 10
Line 10: Incorrect syntax near '@pagesize'.

[yesyesyes]

top后不能用变量
只能拼字符串

[weddingin2008]

咱改？

[子陌红尘]

create proc max_speed
@table nvarchar(20),
@currentpage int,
@pagesize int,
@orderby nvarchar(20)
as
begin
declare @s varchar(1000)
set @s = 'SELECT TOP '+rtrim(@pagesize)+' * FROM '+@table+'
WHERE ('+@orderby+' NOT IN
(SELECT TOP '+rtrim(@pagesize*@currentpage)+' id
FROM '+@table+'
ORDER BY '+@orderby+'))
ORDER BY '+@orderby+''
exec(@s)
end