title: Expand Single Delimited Field into Multiple Columns/Rows
body: <p>I have a text field in a SQL table called <code>Body</code> that contains <strong>multiline</strong> delimited text (see data below for example). I'm looking for help with a SQL query that split the <code>,</code> delimited data out to multiple rows and columns into a temporary table that I can reference in a view.</p>
  
  <pre><code>74,232,3,2700,2619,524,C,0,0,1,47,90,537,9355,0,PA,1,1,SCO1DS,,0,0
  74,232,6,5400,5238,1048,C,0,0,1,47,81,546,6362,0,PB,1,1,INT3DS,,0,0
  74,232,6,837,810,162,C,0,0,75,55,121,100,N694297,0,PC,6,1,GLA2,,0,0
  74,232,8,884,857,171,C,0,0,2,45,90,766,6492,0,PW,8,1,WOL1DS,,0,0
  </code></pre>