CREATE PROCEDURE dbo.UserPaging(
	@sqlStr varchar(5000), 
	@orderBy varchar(1000), 
	@startRow int, 
	@endRow int
)
AS
	SET NOCOUNT ON

	DECLARE @SQLSTRING varchar(5000)
	DECLARE @fieldName varchar(1000)
	DECLARE @tableName varchar(1000)

	SET @fieldName = SUBSTRING(@sqlStr, 8, PATINDEX('%from%', @sqlStr) - 8)
	SET @tableName = RIGHT(@sqlStr, PATINDEX('%from%', @sqlStr) + 6)

	SET @SQLSTRING = N'WITH cte (' + @fieldName + '
         ,___RowNUmber___) AS
 (SELECT ' + @fieldName + ', ROW_NUMBER() OVER (ORDER BY ' + @orderBy + ') AS ___RowNUmber___ 
' + @tableName + ')
  SELECT ' + @fieldName + '
  FROM cte 
  WHERE ___RowNUmber___ BETWEEN ' + CAST(@startRow as varchar(12)) + ' AND ' + CAST(@endRow as varchar(12)) + ''

--	PRINT '@fieldName = ' + @fieldName
--	PRINT '@tableName = ' + @tableName
--	PRINT @SQLSTRING
	EXEC(@SQLSTRING)

	SET NOCOUNT OFF
	RETURN
GO

CREATE TABLE DaTable(
	Id int	identity (1, 1) not null,
	column1	char(10) NOT NULL,
	CONSTRAINT PK_DaTable PRIMARY KEY (Id)
)
GO 

CREATE FUNCTION dbo.GenerateNumList(
	@MaxNum Int
)
RETURNS TABLE 
AS
RETURN 
	WITH cte (num) AS
	(SELECT 0
		UNION ALL
	SELECT num + 1
	FROM cte
	WHERE num < @MaxNum
	)
	SELECT num
	FROM cte
GO

INSERT INTO DaTable(column1)
SELECT 'bla' + CAST(num AS CHAR(10))
FROM dbo.GenerateNumList(10)

EXECUTE dbo.UserPaging 'SELECT Id, column1 FROM DaTable where Id > -1', 'Id', 7, 10
GO

/*WITH cte (Id, column1, ___RowNUmber___) AS
(SELECT Id, column1
		, ROW_NUMBER() OVER (ORDER BY column1) as ___RowNUmber___
FROM DaTable
)
SELECT Id, column1
FROM cte 
WHERE ___RowNUmber___ BETWEEN 7 AND 10
*/

DROP PROCEDURE dbo.UserPaging
GO
DROP TABLE DaTable
GO
DROP FUNCTION dbo.GenerateNumList
GO

SET @fieldName = SUBSTRING(@sqlStr, 8, PATINDEX('%from%', @sqlStr) - 8)
SET @tableName = SUBSTRING(@sqlStr, PATINDEX('%from%', @sqlStr), 4)