Custom Paging Data Procedure

Custom Paging Data Procedure: "CREATE PROCEDURE procGetCustomPagingData
@PageIndex INT = 1
,@PageSize INT = 10
,@RecordCount INT OUTPUT
AS
BEGIN
SET NOCOUNT ON;
SELECT ROW_NUMBER() OVER
(
ORDER BY [ID] ASC
)AS RowNumber
,[Sales_Accounts]
,[Other_Income]
,[Total_Revenue_A]
,[NetProfit]
INTO #Results
FROM [tblmastertable]

SELECT @RecordCount = COUNT(*)
FROM #Results

SELECT * FROM #Results
WHERE RowNumber BETWEEN(@PageIndex -1) * @PageSize + 1 AND(((@PageIndex -1) * @PageSize + 1) + @PageSize) - 1

DROP TABLE #Results
END

"