title: Normalizing CSV file data
body: <p>So I have a CSV file that is formatted like this:</p>
  
  <p>ReturnID|Employee|CreateDate|ProductID|Quantity<br/>
  100|EMP1|2014-09-15|20|500<br/>
  100|EMP1|2014-09-15|21|30<br/></p>
  
  <p>The ReturnID identifies the return and ProductID identifies the product(s) that are associated with a return.</p>
  
  <p>I need to normalize the data from the CSV file and import the data in this form:</p>
  
  <p>A single return record that contains the fields:<br/>
  ReturnID|Employee<br/>
  100|Emp1</p>
  
  <p>and </p>
  
  <p>Two Product records that are associated to the return record. 
  These two records would look something like this:</p>
  
  <p>ReturnID|ProductID|Quantity<br/>
  100|20|500<br/>
  100|21|30</p>
  
  <p>I'm planning using SSIS to import the CSV file, but I would like to do the normalization using SQL Server.</p>
  
  <p>Thanks for your help.</p>