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-06-16 : 09:27:43
|
Brian Quinn writes "Hi,
Is it possible to have a stored procedure accept a dynamic array, which would result in the following SQL being ran:
SELECT stuff FROM tablename WHERE objID = value1
OR objID = value2 OR objID = value3 ...etc etc
where the number of "OR objID = valueX" would vary depending on
the number of elements in the array ?
Enjoy!
Brian Q" |
|
|
|
|
|
Really Dynamic Stored Procedure