>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 ?

Yes, the result will be almost the same. The only differencw will be that temp table created in a store procedure will be automatically deleted when the store procedure finishes.