CREATE PROCEDURE uspGetThatPage
(
	@PageNo INT,
	@RowInPage INT,
	@OrderBy VARCHAR(100)
)
AS

SET NOCOUNT ON

-- Get the Pk in the right order
DECLARE	@Items TABLE (ItemID INT IDENTITY(0, 1), PkColumn INT)

INSERT		@Items
		(
			PkColumn
		)
SELECT		PkColumn
FROM		YourTable
ORDER BY	CASE
			WHEN @OrderBy = 'RegionID' THEN RegionID
			WHEN @OrderBy = 'AddedOn' THEN AddedOn
			ELSE ItemName
		END

-- Now open the records for the right page
SELECT		yt.*
FROM		YourTable yt
INNER JOIN	@Items i ON i.PkColumn = yt.PkColumn
WHERE		i.ItemID / @RowsInPage = @PageNo - 1

CREATE FUNCTION dbo.fnSplitDelimitedString
(
	@Text VARCHAR(8000),
	@Delimiter VARCHAR(8000)
)
RETURNS @Parts TABLE
	(
		i SMALLINT IDENTITY(0, 1) PRIMARY KEY CLUSTERED,
		Part VARCHAR(8000)
	)
AS

BEGIN
	DECLARE	@LastIndex SMALLINT,
		@NextIndex SMALLINT

	IF @Text IS NULL OR DATALENGTH(@Text) = 0
		RETURN

	IF @Delimiter IS NULL
		SELECT	@Delimiter = ';'

	SELECT	@LastIndex = 0,
		@NextIndex = 1

	WHILE @NextIndex > 0
		BEGIN
			SELECT	@NextIndex = CHARINDEX(@Delimiter, @Text, @LastIndex + 1)

			INSERT	@Parts
				(
					Part
				)
			SELECT	CASE
					WHEN @NextIndex = 0 THEN SUBSTRING(@Text, @LastIndex + 1, DATALENGTH(@Text) - @LastIndex)
					ELSE SUBSTRING(@Text, @LastIndex + 1, @NextIndex - @LastIndex - 1)
				END

			SELECT	@LastIndex = @NextIndex
		END

	RETURN
END

Create Function SplitBasedOnNumber
(
	@Number int, 
	@Phrase varchar(8000)
)
Returns @Split Table
(
	InRows varchar(100)
)
As
Begin 
	DECLARE	@LastIndex SMALLINT,
		@NextIndex SMALLINT,
		@Value     Varchar(100)
	
	if (@Phrase is null) Or (@Phrase = '') or (@Number Is Null )
		return 

	if (@Number = 0) or (@Number > Len(@Phrase) )
	Begin 
		Insert @Split 
		Select @Phrase 
		return 
	End 
	
	SELECT	@LastIndex = 0,@NextIndex = 0	
	while @NextIndex < Len(@Phrase)
	Begin 
		Select @value = Substring(@Phrase,@NextIndex,@Number)

		Insert @Split 
		Select @value 
		
		Set @NextIndex = @NextIndex + @Number 
		
	End 
	return 
End 
GO 

Select * From dbo.SplitBasedOnNumber(3,'Hi What up')