title: Insert results from Stored Procedure into table and add an extra column
body: <p>I'm trying to insert data from a stored procedure into a table for example,</p>
  
  <pre><code>INSERT INTO FailedLogins
  EXEC sp_readerrorlog 0, 1, 'Login failed'
  </code></pre>
  
  <p>This works fine, however, I'm running this against hundreds of databases using SSIS so I need to add @@SERVERNAME into my FailedLogins table for each record to match the corresponding server.</p>
  
  <p>So the result set should look as follows:</p>
  
  <pre><code>LogDate  ServerName  ProcessInfo  Text
  </code></pre>