Use list query parameters for SQL IN-clause

[Anonymous]

Hi,

Is it possible to use list query Parameters in a SQL IN clause? Lets say my list contains Organisational Divisons from A to G where I for example choose C and F, can I somehow create a SQL Query like this:

SELECT * FROM mytable WHERE organisation IN (list_of_parameters)

The query would "unwrap" to:

SELECT * FROM mytable WHERE organisation IN ('C', 'F')

Note: My real data contains around 150 divisions and I want to be able to select everything between 1 and all divisons.

Thanks!

// Karl

[v-chuncz-msft]

@Anonymous,

Alternatively, you may try DirectQuery and use a Slicer.