How to cross multiple string parameter

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.

All Forums

SQL Server 2005 Forums

Analysis Server and Reporting Services (2005)

How to cross multiple string parameter

Author

Topic

saxrub
Starting Member

4 Posts

Posted - 2010-02-11 : 09:20:34

hi all,
I use a report based on a query like :
SELECT * from MYTABLE where MYFIELD in (@Param1)

It work fine with one string. I call the report with the URL

http://cx00-qd.atlantica.credit-agricole.fr/CX00QDsrv?%2fDAV600&rs:Command=Render&@Param1='AAA'

But how to cross parameters to the repport to find all the records AAA and BBB

http://cx00-qd.atlantica.credit-agricole.fr/CX00QDsrv?%2fDAV600&rs:Command=Render&@Param1='AAA','BBB'

SELECT * from MYTABLE where MYFIELD in ('AAA','BBB')

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2010-02-11 : 09:23:56

that wont be problem if you pass values as ('AAA,BBB') and use mine or Kristens suggestion
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=139714

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

Kristen
Test

22859 Posts

Posted - 2010-02-11 : 09:29:55

You have already asked the exact same question in this thread:

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=139714

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources