Re: How to Split on specific occurrence of a comma

[leszekdubiel]

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