SQL Server Comma Separate Value and String

Method 1: Split Comma Separated List Without Using a Function
They were storing comma-separated values in a column of the table. This table was getting populated from some source via SSIS package. Here is the simplified version of the problem I was presented.

Method 2: Split Comma Separated List With Using a Function Now we can use STRING_SPLIT function and can achieve that very quickly. Let us understand with a simple example.