title: How to use a special while loop in tsql, do while numeric
body: <p>I'm loading some quite nasty data through Azure data factory</p>
  
  <p>This is how the data looks after being loaded, existing of 2 parts:<br>
  1. Metadata of a test<br>
  2. Actual measurements of the test  -> the measurement is numeric</p>
  
  <p>Image I have about 10 times such 'packages' of 1.Metadata + 2.Measurements</p>
  
  <p><a href="https://i.stack.imgur.com/6Lv8A.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/6Lv8A.png" alt="enter image description here"></a></p>
  
  <p>What I would like it to be / what I'm looking for is the following:
  The number column with 1,2,.... is what I'm looking for!</p>
  
  <p><a href="https://i.stack.imgur.com/3o31G.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/3o31G.png" alt="enter image description here"></a></p>
  
  <p>Imagine my screenshot could go no further but this goes along until id=10
  I guess a while loop is necessary here...</p>
  
  <p>Query before:</p>
  
  <pre><code>SELECT Field1 FROM Input
  </code></pre>
  
  <p>Query after:</p>
  
  <pre><code>SELECT GeneratedId, Field1 FROM Input
  </code></pre>
  
  <p>Thanks a lot in advance!</p>
  
  <p>EDIT: added a hint:
  <a href="https://i.stack.imgur.com/2BSsb.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/2BSsb.png" alt="enter image description here"></a></p>