title: Parse data, single to multiple
body: <p>have a single column <code>Varchar(2000)</code>. </p>
  
  <p>Data looks like in a single column, </p>
  
  <pre><code>12:10:08: Dialing12:10:08: Connecting12:10:08: ABC: abc:9433769781$100.88.77.0:878712:10:08: ABCD: 000012:10:09: Agent Initializing12:10:25: On Call12:10:25: Assigned to operator12:10:25: Waiting for Supervisor12:10:30: Waiting for Manager12:11:30: Call Ended12:11:30: Call Not connected.. 
  </code></pre>
  
  <p>I want to parse it like,</p>
  
  <pre><code>12:10:08: Dialing
  12:10:08: Connecting
  12:10:08: ABC: abc:9433769782$100.88.77.0:8787
  12:10:08: ABCD: 0000
  12:10:25: Agent Initializing
  12:10:18: On Call
  12:10:25: Assigned to operator
  12:10:30: Waiting for Supervisor
  12:10:30: Waiting for Manager
  12:11:30: Call Ended
  12:11:30: Call Not connected
  </code></pre>
  
  <p>Any help. Searched the complete forum, but I am really unsure about this, particularly an absence of a specific identifier. Appreciate your help.</p>
  
  <p>P/S- This is just an example of a single time,time is not constant. </p>