• top 100 percent works fine by me. Tried it on SQL server 2005 MMS. plain select = 888 rows, top 100 percent = 888 rows.