SQL - Delimited Strings to Columns & vice versa!!! - Microsoft SQL Server

This video goes though how to use Microsoft SQL Server 2016 to turn delimited strings into columns and vice versa.

Uses following built in functions -

• string_split - works in (SQL Server 2016 and beyond)
• for xml path()
• stuff
• analytical function (added this in for fun) ... https://www.youtube.com/watch?v=53_tnR4yDGg