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 |
|
Cody
Starting Member
24 Posts |
 Posted - 2009-02-10 : 19:48:10
|
| Hi,In the books I've read where multi-valued parameters are used the authors have said you can't use these in your SELECT statement like:SELECT * FROM somewhere WHERE something IN (@MVP)Because MVP is just a string. So they have you use a function instead that splits the string into a table.I'm running SSRS 2005 with Service Pack 2, and it doesn't seem to work that way. I can do an IN (@MVP), and if I try to use the functions the book authors provide, it complains about too many parameters - as if the MVP is being split already.I couldn't find anything in the release notes. Anyone know? |
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2009-02-11 : 01:31:18
|
| Nope. No such changes in SQL, 2005 any service pack or 2008. Dunno if reporting services is doing anything funny.Try running the queries in management studio, so you can see easily what's happening. What are the queries that you're running and the function definition (or a link, if it's posted online)--Gail ShawSQL Server MVP |
 |
|
|
|
|
|
Did a SSRS service pack change MVPs?