Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
uberbloke
Yak Posting Veteran
67 Posts |
 Posted - 2001-06-15 : 06:02:44
|
I need to store a set of records temporarily and then return them to the client, this is a "success" list and a "failed" list, all from within a Stored Proc.My question is this : which is better, have the SP create a temp table (#status), populate it and then return two recordsets (to the ASP) (select ... from #status where successful|failed) and then destroy the temp table...Or, have one "permanent" table; populate it with success and failure, keying on @@SPID to keep it unique to the processing of that SP, returning the recordsets as above and then deleting the data at the end of the SP.I have done both but am not sure which would be considered the "best" option; also, any other ideas?  |
|
|
|
|
|
Advice Required : best way of storing temp data