title: Copy data from one existing row to another existing row in SQL?
body: <p>I have a table full of tracking data for as specific course, course number 6.</p>
  
  <p>Now I have added new tracking data for course number 11.</p>
  
  <p>Each row of data is for one user for one course, so for users assigned to both course 6 and course 11 there are two rows of data.</p>
  
  <p>The client wants all users who have completed course number 6 any time after August 1st 2008 to also have completion marked for course 11. However I can't just convert the 6 to 11 because they want to preserve their old data for course 6.</p>
  
  <p>So for every row that has a course number of 6, is marked as complete, and is greater than the date August 1st 2008, I want to write the completion data over the row that contains the tracking for course 11 for that specific user.</p>
  
  <p>I would need to carry over the data from the course 6 row to the course 11 row so things like user score and date of posted completion is moved over.</p>
  
  <p>Here is the structure of the table:</p>
  
  <pre><code>userID (int)
  courseID (int)
  course (bit)
  bookmark (varchar(100))
  course_date (datetime)
  posttest (bit)
  post_attempts (int)
  post_score (float)
  post_date (datetime)
  complete (bit)
  complete_date (datetime)
  exempted (bit)
  exempted_date (datetime)
  exempted_reason (int)
  emailSent (bit)
  </code></pre>
  
  <p>Some values will be NULL and userID/courseID obviously won't be carried over as that is already in the right place.</p>