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.
On average if you can strength train 3-4 days a week that is fantastic. 1-2 days is ok but you will not see results as quickly after a few months of training, you will plateau.tudies show you should perform 2-3 sessions of weight training a week with 24-48 hours in between sessions that work the same muscles. For example if you do an upper body workout on Monday do not perform another upper body workout again until at least Wednesday.