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