title: Insert specific rows from one table in database into another with different columns
body: <p>I'm encountering problems moving data from one table to another. I have two tables, one stores all users who are members of a website, however there are VIP members that get random points when they sign up, regular members do not.</p>
  
  <pre><code>+-----------+
  |   Users   |
  +-----------+
  | User_id   |
  | Usertype  |
  | Firstname |
  | Lastname  |
  | Email     |
  | Username  |
  | Password  |
  +-----------+
  
  +-------------+
  | VIP_Members |
  +-------------+
  | User_id     |
  | Username    |
  | Points      |
  +-------------+
  </code></pre>
  
  <p>I want to select all VIP members (determined by Usertype) and move them into <strong>VIP Members</strong> table:</p>
  
  <pre><code>INSERT INTO Vip_Members (Points)
  VALUES (ABS(CHECKSUM(NewId())) % 11)
  SELECT User_id, Username
  FROM Users
  WHERE Usertype = 'vip';
  </code></pre>