CREATE  PROCEDURE [dbo].[LoadPagedCompanies] 
(
    @startRowIndex int,
    @maximumRows int
)
AS

DECLARE @first_id int

SET ROWCOUNT @startRowIndex
SELECT @first_id = CompanyId FROM Company ORDER BY CompanyId

SET ROWCOUNT @maximumRows

SELECT c.*
FROM Company c
WHERE CompanyId >= @first_id
ORDER BY c.CompanyId

SET ROWCOUNT 0

GO

CREATE PROCEDURE [dbo].[SomeProc]
(@parm1 int,@Page int = 1,@RecsPerPage float = 200
,@sortOn varchar(25) = 'assetID'
,@sortDirection varchar(15) = 'DESC') 

AS
 
SET NOCOUNT ON

CREATE TABLE #TempItems (ID int IDENTITY, assetID int)

Insert Into #TempItems (assetID)
SELECT assetID 
FROM SomeTable
WHERE SomeColumn = @parm1				
ORDER BY
	CASE	--Varchar
		WHEN @sortOn = 'assetID' AND @sortDirection = 'DESC' THEN assetID 			
		WHEN @sortOn = 'Column2' AND @sortDirection = 'DESC' THEN Column2 
		ELSE Null 
	END DESC,

	CASE
		WHEN @sortOn = 'assetID'  AND @sortDirection = 'ASC'  THEN assetID 	
		WHEN @sortOn = 'Column2' AND @sortDirection = 'ASC' THEN Column2
		ELSE Null 
	END ASC,

	CASE	--date
		WHEN @sortOn = 'Column3' AND @sortDirection = 'DESC'  THEN Column3
		ELSE Null 
	END DESC,
	
	CASE	
		WHEN @sortOn = 'Column3' AND @sortDirection = 'ASC'  THEN Column3
		ELSE Null 
	END ASC,
	
	CASE	--INT		
		WHEN @sortOn = 'Column4' AND @sortDirection = 'DESC' THEN Column4 		
		ELSE Null 
	END DESC,
	
	CASE		
		WHEN @sortOn = 'Column4' AND @sortDirection = 'ASC' THEN Column4 		
		ELSE Null 
	END ASC

DECLARE @FirstRec int, @LastRec int, @TotalPages int, @totalRecords int 

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

select @totalRecords = (Select count (distinct assetID)) from #TempItems

Select  
	@totalRecords as totalRecords,
	AssetID,
FROM  
	#TempItems TempTable 
Where  (ID >  @FirstRec  AND ID < @LastRec)
Order By ID ASC