title: SQL Query for inserting multi column values in to single column
body: <p>I have Table "MultiCol" as below</p>
  
  <pre><code>Name LibraryID RegisterID EngineerID
  Rahul 1002      4521       4854
  Ajay  5072      3151       4833
  Vimal 4532      4531       4354
  </code></pre>
  
  <p>I want to insert the Rahul's all IDs in the "SingleCol" table(shown below) which is having only one Column named "IDS"</p>
  
  <p>So I want the Result as shown below</p>
  
  <p>Table "SingleCol"</p>
  
  <pre><code>IDS
  1002
  4521
  4854
  </code></pre>
  
  <p>Which query pattern will be most efficient in terms of time and space?</p>