use string_split to actually join your multiple choices to a table! #SQLServer2016 #SQL #TSQL

SQL Server 2016 came out with the STRING_SPLIT function that will return what amounts to a table from character-separated string. Using a CROSS JOIN with this function, you can return one row multiple times with whatever values you want!