executng proc in sql 2005 and sql 2008 givng not proper result

Hi all
when i am executing following procedure in sql2005 its working proper
CREATE PROCEDURE [dbo].[sp_GetHotProjectImagesDetails]
@PageIndex INT = 1
,@PageSize INT = 10
,@RecordCount INT OUTPUT
AS
BEGIN
SET NOCOUNT ON;
SELECT ROW_NUMBER() OVER
(
ORDER BY [DispOrder] ASC
)AS RowNumber
,[ImageId]
,[ProjectId]
,[ImageUrl]
,[Active],
[DispOrder]

INTO #Results
FROM [HotProjectImages]

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
exec sp_GetHotProjectImagesDetails @RecordCount=3
its showing 3 records
when i am executing same in sql server 2008 its not shoing any record

Note:-table on both cases same data also same

Sushat