title: How to update a table with list of values in T-SQL?
body: <p>I have a table that I want to update one-to-many relationship records. The table def is: </p>
  
  <pre><code>CREATE TABLE CT_ProductFailures 
  ( 
  PFID int identity(1,1) PRIMARY KEY NOT NULL, 
  Old_Modes varchar(75), 
  New_Modes varchar(75) 
  ) 
  </code></pre>
  
  <p>Now I want to add records for New_Mode 'N1' with Old_Modes 'A', 'B', 'C'. 
  Other than by doing separate insert statements, how can I achieve this?</p>