How can I copy values of one column into another while changing value of column 2?
<p>I am writing a ASP.NET web app and the customers want to be able to 'clone' a user's group codes to a new user_code.</p>

<p>I have a table <code>userGroup</code> with 2 columns <code>group_code</code> and <code>user_code</code>.</p>

<p>By cloning, I want to get all <code>group_code</code> where the <code>user_code = 'testUser'</code> and copy all of those <code>group_code</code> to a new <code>user_code</code> 'testUser2'. I know I will need to use a parameter, but I'm not sure how to structure my query. </p>