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 ...
|
|---|