Some interesting discussions always evolve around the topic of splitting strings; here I show splitting on the database side may not be necessary in the first place.
With additional tests comparing splitting techniques to TVPs, Aaron Bertrand (@AaronBertrand) rounds out his series on STRING_SPLIT() in SQL Server 2016.
SQL Server 2016 RC0 introduces a new native string splitting function, STRING_SPLIT. Aaron Bertrand (@AaronBertrand) compares its performance to existing methods.