thax you for help .

But I have requestion about temp table.
I find that if I use temp table in ASP (vbscript). every people seem use the same connection so each client share the same temp file. so one client drop the temp table the other client will find the temp table is droped .
I want each user have there own temp table . so it is not work in my case.

if I put it in store procedure is it still the same result ?

Best Regards
Stanley