I am attempting to run a SQL query that uses a string variable that is a list of values. The query is a search where I use “WHERE x IN ______” where the blank is the string variable. I create this string variable by concatenating things together. For example, the string would look something like this (‘0000000’, ‘1111111’, ‘2222222’).
When run the query with that exact string, it runs correctly. However, when I put that string into a variable and pass it as a parameter into the Execute Query activity, it gives me an error regarding the variable.
Has anybody had any success with running a query and this type of string variable? Thanks