thanks for the responses - the query I am currently faced with is this:

SELECT --TOP 100

...