Stored Procedure Paging

[MEM]

I'm fairly new to sql stored procedures. ok, I currently have a stored
procedure that dynamically sorts as well as pages through a recordset:
_______________ _______________ _______________ _______________ _______________

PROCEDURE dbo.ViewAllSale s

@Page int,
@RecsPerPage int,
@SortSQL varchar(100),
@varSession_ID varchar(4),
@varFirstDayMon th_Date datetime,
@varCurrentDayM onthOrder_Date datetime


AS
BEGIN
SET NOCOUNT ON

CREATE TABLE #TempViewSales
(
SalesAutoID int IDENTITY,
TransID int
)

DECLARE @SearchSQL varchar(4000)

SELECT @SearchSQL = 'INSERT INTO #TempViewSales (TransID)' +
' SELECT Transaction_ID FROM tblTransactions WHERE Session_ID =
' + @varSession_ID +
' AND Order_Date >= ''' + Convert(varchar (25),
@varFirstDayMon th_Date, 121) + ''' AND Order_Date <= ''' +
Convert(varchar (25), @varCurrentDayM onthOrder_Date, 121) + '''AND
Active <> 0 ORDER BY ' + @SortSQL
EXECUTE(@Search SQL)

DECLARE @FirstRec int, @LastRec int

SELECT @FirstRec = (@Page - 1) * @RecsPerPage
SELECT @LastRec = (@Page * @RecsPerPage + 1)

SELECT *, MoreRecords = (SELECT COUNT(*) FROM #TempViewSales WHERE
SalesAutoID >= @LastRec)
FROM #TempViewSales INNER JOIN tblTransactions ON
tblTransactions .Transaction_ID = #TempViewSales. TransID
WHERE SalesAutoID > @FirstRec AND SalesAutoID < @LastRec


SET NOCOUNT OFF
END

_______________ _______________ _______________ _______________ _______________

How do i return a record count? And how would i implement a "page x of
y" sceanario? Thanks in advance.