SQL query to split concatenated string into separate parts
<p>Need your expertise in one query: I need a SQL query to split concatenated string into separate parts. My data looks like this</p>

<pre><code>Name  Location           Name Link   Location Link  Final Location     Material
C50   2398::3276::3916   GA-4-2      58::52::24     558::352::324::70  93530
</code></pre>

<p>and i want output like this:</p>

<pre><code>Name  Location           Name Link   Location Link  Final Location     Material
C50   2398               GA-4-2      58             558                93530
C50   3276               GA-4-2      52             352                93530
C50   3916               GA-4-2      24             324                93530
C50                      GA-4-2                     70                 93530
</code></pre>