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.
Both types of activities burn calories, although cardio or aerobic activity is more efficient at this than resistance training, so for the same time period, you will burn more calories by doing cardio activity than lifting weights.ombining both cardio and resistance training is the way to go. But doing it at high-intensity intervals will give the most benefits if you want cardiovascular endurance, fat loss, increased strength and muscle gain. Not only that, but this type of program will take a lot less time than long lifting or cardio sessions.