If you're using T-SQL 2005 or later with MSSQL, there's a much easier way:
select Paged.* from (
[Your select statement goes here, and include this column:]
ROW_NUMBER() over (order by [order you desire in the end]) as RowNum
) as Paged
where Paged.RowNum between @start and @end
order by Paged.RowNum ;
And viola 
Copyright 2014 TriRand LtdAll Rights ReservedRSS
Back to Top