title: Insert data twice into the same table using cursor
body: <p>I have two tables <code>cursor_created</code> and <code>cursor_copied</code> with the same columns. I want to fetch data from <code>cursor_created</code> and insert it into <code>cursor_copied</code> twice using a loop.</p>
  
  <p>Query:</p>
  
  <pre><code>DECLARE @ID INT
  DECLARE @Name NVARCHAR(50)
  DECLARE @Amount DECIMAL(18,0)
  DECLARE @Date NVARCHAR(50)
  
  DECLARE IDs CURSOR FOR 
      SELECT
          ID, Name, Amount, Date 
      FROM
          cursor_created 
  
  OPEN IDs
  
  FETCH NEXT FROM IDs into @ID, @Name, @Amount, @Date
  
  WHILE @@FETCH_STATUS = 0
  BEGIN
      INSERT INTO cursor_copied (id, name, amount, date)
      VALUES (@ID, @Name, @Amount, @Date)
      ----Verify that Data in TestTable
      --print @ID 
      --print @Name
      --print @Amount
      --print @Date
  
      --SELECT @ID, @Name, @Amount, @Date FROM cursor_copied 
      FETCH NEXT FROM IDs into @ID, @Name, @Amount, @Date
  END
  
  CLOSE IDs
  DEALLOCATE IDs
  </code></pre>
  
  <p>Output:</p>
  
  <pre><code>ID  Name  Amount  Date
  ------------------------------------------
  1   A     2000    2008-03-15 18:15:43.000
  2   B     3000    2008-03-15 18:15:43.000
  3   C     4000    2008-03-15 18:15:43.000
  </code></pre>
  
  <p>I would like this instead:</p>
  
  <pre><code>ID  Name  Amount  Date
  ------------------------------------------
   1  A     2000    2008-03-15 18:15:43.000
   2  B     3000    2008-03-15 18:15:43.000
   3  C     4000    2008-03-15 18:15:43.000
   1  A     2000    2008-03-15 18:15:43.000
   2  B     3000    2008-03-15 18:15:43.000
   3  C     4000    2008-03-15 18:15:43.000
  </code></pre>