title: Insert Dynamic & Static Data into Temp Table
body: <p>I'm new to using "Insert" functions, and know enough SQL to be dangerous. </p>
  
  <p>I am trying to generate my own duplicated row data by using a combination of dynamic and static data. I'm using SQL Server 2012. </p>
  
  <p>Example of need below.</p>
  
  <pre><code>Create table #Temp
  (Item nchar(32),
  Company nchar(32))
  ;
  
  Insert Into #Temp (Item, Company)
  VALUES
  (X, 'Company1'),
  (X, 'Company2')
  ;
  </code></pre>
  
  <ul>
  <li>"Company1" and "Company2" is the "Static" part that I am manually adding.</li>
  <li>"X" above in this case is Item number from a select statement [<code>Select Item From Table</code> and is the "dynamic" part as the number of items returned increases every day. </li>
  </ul>
  
  <p>We'll pretend that today the "Table" has only two item numbers, 100 and 200. So my end result would be adding each instance of Company to each item number as follows:</p>
  
  <pre><code>Item |Company
  ----------
  100 | Company1
  100 | Company2
  200 | Company1
  200 | Company2
  </code></pre>
  
  <p>Thank you in advance!</p>