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 - 2001-11-07 : 09:07:55
|
| PeterG writes "I am developing an asp page where I would have to connect to two databases to display the correct information on my page. The tables I need are on two separate DBs on the same server. Here is how I envision the whole thing:1. I connect to the first DB and grab the records I need. The records could be one or more, and if there is more than one I'd write them into an array (using rs.getRows()).2. I then open the second database and use these array values asparameters for the stored procedure to be executed. I don't know if this is the best way to do this, and if it is how do I write the stored procedure to be dynamic, i.e, it would accept from 1 to many parameters.Any help would be appreciated. Thanks." |
|
|
|
|
|
Array As Incoming Parameters for Stored Proc?