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.
These tips for safe strength training will help you get the most from your workouts: 1  Plan to warm up and cool down for five to 10 minutes. 2  Focus on form, not weight. 3  Tempo, tempo. 4  Breathe. Keep challenging muscles.  Practice 1  regularly. Give muscles time  off.