Parsing from a list in sql
<p>I currently have a db table that list an employee and their rights like so:</p>

<pre><code>User          Groups
Johnson       DB~LB~AP
Doe           DB~PLA
</code></pre>

<p>I need a parsing function that is able to list out all users and all associated groups, like so:</p>

<pre><code>User          Groups
Johnson       DB
Johnson       LB
Johnson       AP
Doe           DB
Doe           PLA
</code></pre>

<p>I was able to find this awesome parsing function (<a href="http://sqlfool.com/2011/05/string-parsing-function/" rel="nofollow">http://sqlfool.com/2011/05/string-parsing-function/</a>), but I'm unable to run this for a list of users. I can run the parsing function for one user at a time but am stumped on how I can run a list of users through this function.</p>

<p>Any help is greatly appreciated!</p>