SQL Server XML - Un-Making a List (or Shredding of Evidence)

added by jacobsebastian
5/26/2010 10:25:50 PM

0 Kicks, 44 Views

In my previous blog entry described in detail how you could use the FOR XML clause to create a column with a comma-separated list of entries acquired from rows in a table somewhere. In this article, we will do the opposite… We will take a comma-separated list and “shred” the individual items into rows.