How to Make a Delimited List in One Field from Values in Many Rows Using TSQL
For data engineers doing transformations, one common problem is how to show non-summary data in one column to support things like summed totals. In this example, we'll use TSQL to sum up sales totals, then add a column to show the colours of all cars sold for those totals in a delimited list, in one column. See how this transformation is done! Best viewed on a larger screen.