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 |
|
Franco Well
Starting Member
23 Posts |
 Posted - 2004-11-19 : 09:33:04
|
| Is there a way to design a parameter that allows the user to enter multiple values? EG:Parameter: @Planpart of the where clause: m.Plan In ( + @Plan )and let's say the user enters T1,T2,T3 into the parameter boxI know this doesn't work...does anyone know of a way to make it work?Thanks for your ideas.......Franco |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2004-11-19 : 09:44:00
|
| The SQL Team FAQ has the answer:http://www.sqlteam.com/faq.asp |
 |
|
|
Franco Well
Starting Member
23 Posts |
Posted - 2004-11-19 : 12:01:11
|
| Thanks for the article.I'm still puzzled....what part of the article adresses this issue?Thanks....Franco |
|
|
|
jsmith8858
Dr. Cross Join
7423 Posts |
|
|
Franco Well
Starting Member
23 Posts |
Posted - 2004-11-19 : 13:18:09
|
| Thanks JeffYes, the FAQ does link to the item you just gave me. In fact, I even read that part. Since this is still relatively new to me, I simply didn't recognize it as the applicable part of the article.Thanks again.....Franco |
|
|
|
jsmith8858
Dr. Cross Join
7423 Posts |
Posted - 2004-11-19 : 13:45:34
|
| the entire article -- from the question in the beginning to the very last word -- directly talks about exactly what you are trying to do ! you may need to get some books on T-SQL and do some basic SELECT's and such before continuing, if none of that made sense to you. - Jeff |
|
|
|
jhermiz
3564 Posts |
Posted - 2004-11-19 : 18:54:53
|
quote:
Originally posted by Franco Well
Thanks JeffYes, the FAQ does link to the item you just gave me. In fact, I even read that part. Since this is still relatively new to me, I simply didn't recognize it as the applicable part of the article.Thanks again.....Franco
Funny cause i asked the same question just 5-6 days ago and good ol jeff posted that same link.Works a treat too!Thanks again.Franco if you need more help with this just ask!Jon |
|
|
|
Franco Well
Starting Member
23 Posts |
Posted - 2004-11-23 : 08:45:10
|
| JonI'll probably need more help with this down the line. I have not had a chance to really study the article in-depth. I'll take your word that the answer to my post is contained in the article, especially since you had the same question and found an answer.Franco |
|
|
|
|
|
|
Multiple values in a parameter