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.
This is energy your muscles would have normally used for weight lifting. So, when you go to lift weights in this state, your body will utilize protein for energy instead, and the protein it will use is from your muscles. So in essence, you're defeating the purpose of weight lifting by doing it after cardio. So, if you must do them on the same day, you should do cardio after weights. For maximum benifit, have a small fast uptake protein/carb supplement between the weights and cardio and wait a few minutes before starting - it would be a good time to do some deep stretches.