Can I use @table variable in SQL Server Report Builder?
Posted
by edosoft
on Stack Overflow
See other posts from Stack Overflow
or by edosoft
Published on 2010-04-23T15:00:45Z
Indexed on
2010/04/23
15:03 UTC
Read the original article
Hit count: 300
Using MS SQL 2008 Reporting services:
I'm trying to write a report that displays some correlated data so I thought to use a @table variable like so
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
However, Report Builder keeps asking to enter a value for the variable @Results. It this at all possible?
© Stack Overflow or respective owner