title: INSERT - EXEC problem. Empty output from stored procedure
body: <p>I need to <code>SELECT</code> specific data from stored procedure output so I am trying to insert the stored procedure's output into a table. I am very newbie in SQL. </p>
  
  <p>So here is the code:</p>
  
  <pre><code>Declare @result table
  (
      row_id int,
      quarry nvarchar(400),
      interval nvarchar(100),
      vskr_plan decimal(30,1),
      vskr_fact decimal(30,1),
      vskr_diff decimal(30,1),
      ruda_plan decimal(30,1),
      ruda_fact decimal(30,1),
      ruda_diff decimal(30,1),
      gpr_plan decimal(30,1),
      gpr_fact decimal(30,1),
      gpr_diff decimal(30,1),
      gm_plan decimal(30,1),
      gm_fact decimal(30,1),
      gm_diff decimal(30,1)
  )
  
  INSERT INTO @result
      EXEC [report].[DISP_KPI_QUARRY] @datet = N'2018-10-11'
  
  SELECT * 
  FROM @result
  </code></pre>
  
  <p>I have no errors with this code but it returns an empty table! </p>
  
  <p>However if I execute:</p>
  
  <pre><code>EXEC [report].[DISP_KPI_QUARRY] @datet = N'2018-10-11'
  </code></pre>
  
  <p>I see all the data.</p>
  
  <p>What is my mistake, guys?</p>