CREATE PROCEDURE sp_PagedEquipment_sent
	(
	 @Page int,
	 @RecsPerPage int,
	 @SearchCriteria char(255),
	 @SearchOrder char(50)
	)
AS

-- We don't want to return the # of rows inserted
-- into our temporary table, so turn NOCOUNT ON
SET NOCOUNT ON

-- Find out where we will start our records from
DECLARE @RecCount int
SELECT @RecCount = @RecsPerPage * @Page + 1


--Create a temporary table
CREATE TABLE #TempItems
(
	ID int IDENTITY,
	EquipmentID int,
	Picture char(50),
	Category char(75),
	myYear int,
	Make char(15),
	Model char(15),
	Company char(10),
	Availability char(15)
)

-- Create the dynamic sql statement
DECLARE @mySQL varchar(2000)
SELECT @mySQL = "SELECT EquipmentID, Picture, Category, myYear, Make, Model, 
			Company, Availability FROM EQUIPMENTLIST " 
			+ @SearchCriteria + " " + @SearchOrder

-- Insert the rows from tblItems into the temp. table
INSERT INTO #TempItems (EquipmentID, Picture, Category, myYear, Make, Model, Company, Availability)
EXEC(@mySQL)

-- Find out the first and last record we want
DECLARE @FirstRec int, @LastRec int
SELECT @FirstRec = (@Page - 1) * @RecsPerPage
SELECT @LastRec = (@Page * @RecsPerPage + 1)

-- Now, return the set of paged records, plus, an indiciation of we
-- have more records or not!
SELECT *,
      MoreRecords = 
	(
	 SELECT COUNT(*) 
	 FROM #TempItems TI
	 WHERE TI.ID >= @LastRec
	) 
FROM #TempItems
WHERE ID > @FirstRec AND ID < @LastRec


-- Turn NOCOUNT back OFF
SET NOCOUNT OFF