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-04-11 : 11:51:09
|
Tony writes "I have a typical requirement here;
I am writing a stored procedure in MS SQL 2K which would be called by my cold fusion template; Now this cold fusion template has a dynamic length list (eg: brand= 1,2,3,4,5,6,7)
I have to use this list in IN Clause of sql query. I have brand table with int type id in which i have to perform where id IN (brandValues)
I am trying to pass this list type variable but so far no luck in parsing the values individually.
Point to ponder is this list is dynamic ie. of varying length.?
any ideas or suggestions. please!!!
thankyou in anticipation" |
|
|
|
|
|
Stored Proc : Passing dynamic-comma-delimited list of numbers