Both machines are hitting the same DB on the same server. Its MySql 5.0.12.

The proc in question is only returning one result set which is another reason why this issue baffles me.

The proc does a series of joins into a temporary table. It then does a 'select distinct' which creates the result set that Im looking for.