title: Can I use @table variable in SQL Server Report Builder?
body: <p>Using SQL Server 2008 Reporting services:</p>
  
  <p>I'm trying to write a report that displays some correlated data so I thought to use a @table variable like so</p>
  
  <pre><code>DECLARE @Results TABLE (Number int
                         ,Name nvarchar(250)
                         ,Total1 money
                         ,Total2 money
                         )
  
  insert into @Results(Number, Name, Total1)
  select number, name, sum(total)
  from table1
  group by number, name
  
  update @Results
  set total2 = total
  from
  (select number, sum(total) from table2) s
  where s.number = number
  
  select from @results
  </code></pre>
  
  <p>However, Report Builder keeps asking to enter a value for the variable @Results. It this at all possible?</p>
  
  <p><strong>EDIT:</strong> As suggested by KM I've used a stored procedure to solve my immediate problem, but the original question still stands: can I use @table variables in Report Builder?</p>