title: Move SQL data from one table to another
body: <p>I was wondering if it is possible to move all rows of data from one table to another, that match a certain query?</p>
  
  <p>For example, I need to move all table rows from Table1 to Table2 where their username = 'X' and password = 'X', so that they will no longer appear in Table1.</p>
  
  <p>I'm using SQL Server 2008 Management Studio.</p>