One potential difference is that the tables in the From clause do not include their schema names. Thus, if his login has a different credential than yours, it might be a problem with implicit schemas. That can cause all kinds of weird behavior, including odd performance issues.
Can you fix the query so it uses two-part names for the objects in the From clause? Like "dbo.TableName" instead of just "TableName".
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon