Thanks for your valuable suggestions.
But My question was not a single select.... like
select * from customer where country = 'USA'
select * from customer where country = 'UK'
select * from customer where country = 'Germany'
If the same select is something like "select * from customer where country='USA' into table temp1"....and it's executed by three users simultaneously as I told what happens to the temp1 table....Can we return the temp1 table from the SP as such
Moreover I agree your point on the usage of temp. tables.