title: How can INSERT INTO a table 300 times within a loop in SQL?
body: <p>I would like to insert a value retrieved from a counter in SQL and repeat it 300 times.</p>
  
  <p>Something like:</p>
  
  <pre><code>DECLARE @Counter = 0;
  
  -- BEGIN Loop 
      SET @Counter = @Counter + 1 
      INSERT INTO tblFoo VALUES(@Counter)
  -- REPEAT 300 times
  </code></pre>
  
  <p>How can I achieve this?
  Thanks</p>