June CTP - Multi Value Parameter

Hot Topic

SSAS 2005 with Kerberos/Delegation
Error processing events
SSIS Package Configurations Stored in SQL Server Table
About alias of data field
Timeout expires when deploying assemblies in SQL Server 2005 June CTP
How aggregations are merged
Problem attaching a database
Stored Procedure to executing an SSIS Package
Want to reference connection managers from within a data flow task/Custom Connection Manager
SQL Backup: Database needs to be in single user mode.

SQL Server

Plase HELP ! SQL ERROR =>> An I/O error occurred while receiving the TDS prelogin response.
SQL Native Client Issue
this should be easy but it's not.
New Java driver for SqlServer
Transforming Old Data to a new database with different relationships
Running SQL server 2000 & 2005 side by side
Loading Fact Table
Reporting Services
SQL cannot read the domain name
Where is the package running?

June CTP - Multi Value Parameter

I have a string report parameter with Multi-value checked. The multi-value list generated does not contain quotes around each string values. Is there a simple way to accomplish this I want to include this list in the IN of the WHERE clause.

Thanks,

Answer this question

June CTP - Multi Value Parameter

  • Jeffrey B. Holtz

    Stored procedures do not natively support a multi-valued parameter. You will need to pass a string and parse within the SP.

  • Raj

    You don't need to add single quotes to string parameters. It generates quotes by itself.

  • angrycoder2

    Is your query string an expression, i.e. starting with = sign If so, I think you are correct that the entire list is returned within single pair of quotes. However, when the the query string is not an expression, WHERE column IN (@param) worked just fine.

  • Matthew Mitrik MSFT

    Thanks! I was trying to use the Parameter in an expression for a dataset, but none of that is necessary, at least in my case.  IN (@ParmName) works just fine.

    Thanks for your help.

  • Todd Potter

    I have been trying to pass the string values so that the

    WHERE column IN (@param) works.

    The only quotes that are generated are 'value1, value2'
    where as the following are required 'value1', 'value2'

    Is there a special setting somewhere to generate these quotes

    Help please

  • Dmitriy Nikonov MSFT

    I am actually trying to execute a stored procedure to populate the report.
    So the dataset type is Stored Procedure instead of Text.
    Therefore the parameters are passed in the expression format as you said.

    How do I pass them otherwise

    Thanks
  • June CTP - Multi Value Parameter
Answer this question