Another solution is to use TOP to fetch the first count + offset rows, and then use the API to seek past the first offset rows. See also:  1  Emulate MySQL LIMIT clause in Microsoft SQL Server 2000 2  .  Paging of Large Resultsets in ASP.NET .
If you need to condense your workouts and do both cardio and weight training on the same day, then it may be a good idea to start with the cardio exercises before beginning the strength training part of your workout.
Itâs a simple equation: the more muscle you can get working, the more it will challenge your heart and your cardiovascular system. Instead of building cardio-only workouts (the pitfall thatâll prevent you from building endurance) make sure to weave strength days into your training. âMost people reserve one day for strength and another day for cardio. Try combining the two instead,â says Torres.