title: Insert Into a table a variable outside of the SELECT results
body: <p>I am working on a Stored Procedure on MSSQL. This is a simplified example of my case.</p>
  
  <pre><code>another code that has declared a variable @Country
  ...
  ...
  ...
  INSERT INTO Customers (CustomerName, Country)
  SELECT SupplierName, Country FROM Suppliers;
  </code></pre>
  
  <p>So, what I try to do is instead of the <code>Country</code> value of the <code>SELECT</code>, insert the <code>@Country</code> variable of the previous code, but keep the <code>SupplierName</code> from the results.</p>
  
  <p>I wasn't able to find a similar question and trial and error didn't help.</p>