title: INSERT into another table, and then DELETE from the source table
body: <p>How can I delete the first 18 rows (sorted by FIELD1) from the "pippo" table, and then insert THE SAME 18 rows in another clone-table called minnie?</p>
  
  <p>The following code extracts the first 18 rows ordering by FIELD1, and then deletes them:</p>
  
  <pre><code>WITH  q AS
          (
          SELECT TOP 18 *
          FROM    pippo
          ORDER BY FIELD1 ASC /* You may want to add ORDER BY here */
          )
  DELETE
  FROM    q
  </code></pre>
  
  <p>How can I insert the same 18 rows into the minnie table, before deleting them?</p>
  
  <p>Thank you in advance for your kind help.</p>