|
-
Sep 29th, 2000, 10:40 AM
#4
Why not make a permanent table and add an extra column which holds the @@SPID of the connection you are using or a client unique ID.
Then you could just pass the ID into the stored procedure that you want it to act on.
Temp tables are pretty bad normally, they can severely degrade performance as the indexing on them is different from permanent tables.
John.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|