• Surprisingly, I can also do cross apply...

    There might be some difference with running sql server 2005 (set to compatible to sql server 2000 ) and running sql server 2000 directly?