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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2005-06-09 : 08:29:41
|
| Ryland writes "I have a situation where, via linked servers, I request data from 7 oracle servers and pool it to a staging table.The pulls are individually rather slow. I'd like to create a SP where I pass a parameter from Stored Proc 1 (the date of the data I'm requesting, '6/5/05' for example) to stored proc 2, and then the staging table is purged (TRUNCATE TABLE) and then the seven statements independently and simultaneously execute INSERT statements. When all 7 inserts have completed, I need to detect this and return control to the original calling procedure (stored proc 1).I'm doing this from SQL. Your help is greatly appreciated!!!Thanks,-R" |
|
|
X002548
Not Just a Number
15586 Posts |
|
|
Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)
7020 Posts |
Posted - 2005-06-09 : 09:47:45
|
| You could use DTS to run them in parallel.CODO ERGO SUM |
 |
|
|
|
|
|
Asynchronously running queries