CREATE Procedure Joke_pages
(
@Sql nvarchar (4000),
@Page Int,
@RecsperPage Int,
@ID varchar (255),
@Sort varchar (255)
)
AS
Declare @str nvarchar (4000)
Set @ Str = 'SELECT TOP' CAST (@Recsperpage As Varchar (20)) '* from (' @ SQL ') T where t.' @id 'Not in (SELECT TOP' CAST ((@ Recsperpage * (@ Page-1)) AS VARCHAR (20)) '' @ ID 'from (' @ SQL ') T9 Order By' @ Sort ') Order by' @ Sort
Print @str
EXEC SP_EXECUTESQL @STRGO
