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 |
|
jeroena
Yak Posting Veteran
76 Posts |
 Posted - 2002-10-14 : 10:19:46
|
| Hi all,Does anyone know a design pattern or something for the following:I query an external datasource and get hold of, say 10 identifiers, which are large strings and represent certain documents. I have a SQL Server database in which I want to administer some attributes of these documents (and the identifiers of course). Now I want to call a SP which returns the attributes for these 10 string identifiers. How to do this? Should I pass the string in some array obejct to the stored procedure?I want to avoid calling the SP 10 times, each time with one identifier...Hope to hear from you...Jeroen. |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2002-10-14 : 10:49:21
|
| http://www.sqlteam.com/SearchResults.asp?SearchTerms=csv |
 |
|
|
jeroena
Yak Posting Veteran
76 Posts |
Posted - 2002-10-15 : 02:54:36
|
| Okay, then CSV it is...Thnx.Jeroen. |
|
|
|
|
|
|
Passing an array to a stored procedure