how to convert a comma separated list into rows in sql server
I'm going to show you how to use the table function string_split to normalize fields with multiple values. The cross apply construct (introduced by sql server in LINQ) is used to apply the function to all rows from a table
