title: ms sql insert into value from variable and select from table
body: <p>I want to insert into a table an value from variable and an select result.</p>
  
  <pre><code>declare @actual Date
  set @actual = getdate()
  </code></pre>
  
  <hr>
  
  <p>This is my try:</p>
  
  <pre><code>insert into test (ID, Date) (select ID, @actual from Table)
  </code></pre>
  
  <hr>
  
  <p>I get an error Message!!</p>