Multiple Values in same parameter

Hello there,

I'm trying to run a query from a sql external data, in which i can can choose multiple values. I've tried to edit MS Query in order to choose only the values that i want, but it seems there's a limit to how many criteria can be add in on conditional.

I've also tried to proceed as explained in the link above, with no luck.

http://datapigtechnologies.com/blog/...one-parameter/



I'm trying to add 45 values to the same parameter, diferenced by ",".

Can you help?

Thank you, and sorry for my english.

Here is the code:


SELECT Test."Date 1", Test."Date 2", Test."Date 3", Test."Date 4", Test.Segmento, Test."Id Value", Test."ID", Test."User", Test.City FROM Leftover.Test Test WHERE (Test."Date 4">=? And Test."Date 4"<=?) AND (Test."ID" = ?)

Parameter 1 - "A1" - Date Value
Parameter 2 - "A2" - Data Value
Parameter 3 - "A3" - Multiple Values(ID452, ID359, ID101, ID789, ID7855, ID124, ID987)

This is what a table is for. Build a table of items you want to search, join it to the data table.
boom. multiple params.

Thanks for the reply ranman, but i guess i didn't explained well. I can put it to work with parameters just fine. the issue is when i try to insert more than one value in the same parameter.

Exactly. Use a joined table.

Using a joined table, the query will only show the data a inserted? Didn't know that. Can i join with Excel Sheet or do it with a Excel Table? I don't can't edit in the sql server, because our client refuses to share the acess to edit.