Un-Making a List (or Shredding of Evidence)
In my previous blog entry , I 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%26hellip; We will take a comma-separated list and %26ldquo;shred%26rdquo; the individual items into rows. Let's start by creating and populating a test table: create table #CSVLists ( ID int ,Description varchar(30) ,CSVList varchar(200) ) insert #CSVLists select 1,'Stoog
Blog Content
No comments:
Post a Comment