title: SQL Server query - how to insert selected values into another table
body: <p>Here's what I am trying to do.</p>
  
  <p>This is the select statement</p>
  
  <pre><code>select Id 
  from tblUsersPokemons 
  where UserId = 1 and PokemonPlace = 'bag'
  </code></pre>
  
  <p>Now I want to insert those returned Ids into another table like this:</p>
  
  <pre><code>foreach all returned Ids
     insert into tblNpcBattleUsersPokemons values (Id, 1)
  </code></pre>
  
  <p>How can I do that ?</p>