[LINKEDSERVER].TBRWeb.dbo.TeamMaster TM ON TS.TeamID = TM.TeamID WHERE Project = 1 ORDER BY StatsDate DESC, OverallRank ASC </pre><BR><BR>So, to answer your question, SQL Server seems to be smart ...