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 |
|
SQLBoy14
Yak Posting Veteran
70 Posts |
 Posted - 2014-03-06 : 22:24:16
|
| Hi all,I have a question:I am writting the T-SQL using some parameters. One of the parameter is to display the ZoneID which has about 2100 records. So I declare the parameter (called it @ZoneID varchar(max)). Now, how do I make all the value available for multiple selection? For example, if I execute the query, I can put the ZoneID (for example:) YH09, TR45, TTS0.Thank youSQLBoy |
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
|
|
SQLBoy14
Yak Posting Veteran
70 Posts |
Posted - 2014-03-06 : 22:45:05
|
| Thank you Khtan. I checked the link and very helpful. Thank you.SQLBoy |
 |
|
|
|
|
|
Multiple value in single parameter