Dynamic input tool -Different sql query method?

[BosKev]

Hey All,

I'm running a simple setup currently in Alteryx where I feed in a list of IDs and query a view in a database for results.

I used "modify SQL query" option to replace 

where ID = 'xxxx' with a list of IDs from another input, this works well for small number of IDs...say less than 100 but if I'm to query a large list with thousands of IDs it would take forever as the dynamic tool is query each individual ID separately.

Is there a better solution? Thanks.

[BosKev]

@AbhilashR , no problem, we all learn something new...now this doesn't entirely solve my originally problem as my list is over 1000 IDs, I would need to break it into parts...lol