title: insert statement one column from another table rest of the columns is values
body: <p>would like to know how to write SQL query, when you want to use the insert statment and fill it with 2 values and then a value from a external table?</p>
  
  <p>Something like this. </p>
  
  <pre><code>INSERT INTO [PPLAT_KPI].[dbo].[KPI_Values]
         (TS,
         Value,
         ID)
   VALUES
         ('2010-02-04'
         ,'200',
             SELECT KPI_Parameter.ID
           FROM [PPLAT_KPI].[dbo].[KPI_Parameter] 
              where KPI_Parameter.Site = 'XXX' and KPI_Parameter.Plant = 'vv';)
  </code></pre>