June CTP - Multi Value Parameter
Thanks,
Thanks,
Thanks for your help.
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
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.
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