title: SQL While Loop Insert with values from another table
body: <p>I am trying to create a SQL While loop that will update a temp table with values from another table. Values from the other table:</p>
  
  <pre><code>477286
  560565
  499330
  391827
  127375
  526354
  501736
  357359
  410433
  500946
  261297
  377667
  135931
  235691
  247239
  143672
  548752
  471945
  ...
  </code></pre>
  
  <p>Wrote the following, however, it only inserts the last value multiple times over.</p>
  
  <p>Here is the code:</p>
  
  <pre><code>USE Reports
  GO
      CREATE TABLE #TempTable (CreatedByID int, LastUpdatedByID int, ID int, 
  AlertDE int, Alert char(50), StartDTTM datetime, EndDTTM datetime, 
  IsInactiveFLAG char(1),AlertDetails char(1));
      DECLARE @numrows INT
      SELECT @numrows  = COUNT(*) FROM [Reports].[dbo].[Eligible]
      DECLARE @id int 
      DECLARE @LoopCount INT = 1
      DECLARE @count int = @numrows
      SELECT  @id = [id] FROM [Reports].[dbo].[Eligible]
  WHILE (@LoopCount &lt;= @count)
  BEGIN  
      INSERT INTO #TempTable (CreatedByID, LastUpdatedByID, ID, AlertDE, Alert, StartDTTM, EndDTTM, IsInactiveFLAG,AlertDetails) 
      VALUES (52,52,@id,0,'Eligible',CURRENT_TIMESTAMP,'1900-01-01 
  00:00:00.000','N','') 
      SET @LoopCount = @LoopCount + 1
  END 
  SELECT * FROM #TempTable
  DROP TABLE #TempTable
  </code></pre>
  
  <p>I am assuming I have to tell it to loop through the values in the other table somehow but I am not positive if that is the right approach or if in general I am taking the long way around the bus.</p>