in reply to How to Split on specific occurrence of a comma

Dont' build "IN" SQL clause. Build temporary table and join with that table

SELECT * INTO #MyTempTable FROM (VALUES @{[ $placeholders ]}) AS Temp (Xxx); SELECT .... JOIN #MyTempTAble MTT ON MTT.Xxx = ... WHERE ... GROUP BY ...