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.
Here are some principles you probably want to take on board before you start your strength program. Follow these principles and you will become stronger without affecting your sport-specific skill set, and stay injury free in the process. Principle #1 - Focus on the Sport. Strength training is supplementary. While having big numbers in the gym is good for your ego, no one cares about your bench press, squat, deadlift, or whatever numbers you get in the gym if you suck at your art or sport. Strength is just one facet of your training and one athletic attribute.