Paging Query

I have created a stored proc for paging on a datalist which uses a objectDataSource.

I have a output param itemCount which should return the total rows. Them I am creating a temp table to fetch the records for each page request. My output param works fine if I comment out all the other select statements. But returns null with them. Any help would be appreciated.

CREATE PROCEDURE [dbo].[CMRC_PRODUCTS_GetListByCategory]
(
 @categoryID int,
 @pageIndex INT,
 @numRows INT,
 @itemCount INT OUTPUT
 
)
AS

SELECT @itemCount= COUNT(*) FROM CMRC_Products where CMRC_Products.CategoryID=@categoryID
 
 Declare @startRowIndex INT;
 Declare @finishRowIndex INT;
 set @startRowIndex = ((@pageIndex -1) * @numRows) + 1;
 set @finishRowIndex = @pageIndex * @numRows
 

DECLARE @tCat TABLE (TID int identity(1,1),ProductID int, CategoryID int, SellerUserName varchar(100), ModelName varchar(100), Medium varchar(50),
ProductImage varchar(100),UnitCost money,Description varchar(1500), CategoryName varchar(100), isActive bit,weight money)

INSERT INTO @tCat(ProductID, CategoryID,SellerUserName,ModelName,Medium,ProductImage,UnitCost,Description,CategoryName, isActive,weight)
SELECT     CMRC_Products.ProductID, CMRC_Products.CategoryID, CMRC_Products.SellerUserName,  CMRC_Products.ModelName, CMRC_Products.Medium,CMRC_Products.ProductImage,
                      CMRC_Products.UnitCost, CMRC_Products.Description, CMRC_Categories.CategoryName, CMRC_Products.isActive,CMRC_Products.weight
FROM         CMRC_Products INNER JOIN
                      CMRC_Categories ON CMRC_Products.CategoryID = CMRC_Categories.CategoryID
WHERE     (CMRC_Products.CategoryID = @categoryID) AND (CMRC_Products.isActive = 1)

SELECT    ProductID, CategoryID,SellerUserName,ModelName,Medium,ProductImage,UnitCost,Description,CategoryName, isActive,weight
FROM         @tCat
WHERE TID >= @startRowIndex AND TID <= @finishRowIndex
GO