CREATE PROCEDURE sp_PagedItems_TEST
	(
	 @Page int,
	 @iRecordsPerPage int,
	 @startdate datetime,
	 @enddate datetime,
	 @whichcomp varchar(256),
	 @cat1 varchar(25),
	 @cat2 varchar(25),
	 @orderby int
	)
AS

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


--Create a temporary table
CREATE TABLE #TempItems
(
	ID int IDENTITY,
	EventLog varchar(256),
	RecordNumber int,
	TimeGenerated datetime,
	EventID int,
	EventType int,
	EventTypeName varchar(256),
	EventCategory int,
	SourceName varchar(256),
	ComputerName varchar(256),
	Message varchar(512),
)


-- Insert the rows from tblEvents into the temp. table
INSERT INTO #TempItems (EventLog, RecordNumber, TimeGenerated, EventID, EventType,EventTypeName, EventCategory, SourceName, ComputerName, Message)
SELECT     EventLog, RecordNumber, TimeGenerated, EventID, EventType,EventTypeName, EventCategory, SourceName, ComputerName, Message
FROM         tblEvents
where (TimeGenerated between @startdate and @enddate)
AND (ComputerName like '%' + @whichcomp + '%')
AND (EventLog like '%' + @cat1 + '%')
AND (EventTypeName like '%' + @cat2 + '%')
ORDER BY CASE WHEN @orderby = 2 THEN ComputerName
WHEN @orderby = 3 THEN TimeGenerated
WHEN @orderby = 4 THEN EventID
WHEN @orderby = 5 THEN SourceName
ELSE RecordNumber
END

-- Find out the first and last record we want
DECLARE @FirstRec int, @LastRec int
SELECT @FirstRec = (@Page - 1) * @iRecordsPerPage
SELECT @LastRec = (@Page * @iRecordsPerPage + 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
ORDER by TimeGenerated

-- Turn NOCOUNT back OFF
-- SET NOCOUNT OFF
GO