For anyone stumbling across this post using SQLSERVER 2016+
From SQL version 13 See this blog post
https://blog.sqlauthority.com/2018/05/04/sql-server-split-comma-separated-value-string-in-a-column-using-string_split/

Simply
SELECT ID,...