Do you mean some sort of pagination query kind of thing

SELECT TOP 100 * FROM (SELECT

ROW_NUMBER() OVER (ORDER BY Date) AS RowNumber,

*

FROM

...

I agree with Paul. The convention I follow is that

1. If I need the columns in the select list from only 1 of the tables then I use subquery....