Home Forums SQL Server 2005 T-SQL (SS2K5) How to return a certain percentage of rows (NOT TOP PERCENT QUESTION) RE: How to return a certain percentage of rows (NOT TOP PERCENT QUESTION)

  • Thanks all, I'm out of the office so I'll test your solutions tomorrow.

    Just to clarify, what I wanted was to first order the rows in the temp table by number (desc) and then count 60% from the top downwards. Once 60% has been reached, or as close to, then stop. I see that you've already guessed that though!