Reportviewer and Temp Variables

Reportviewer and Temp Variables

kick it on DotNetKicks.com   While working with report viewer and Stored procedures which uses temporary variables
you might have got the problem of not getting schema in dataset. To resolve this issue use Table variables to return table instead of returning usine table varaibles
like select * from #temp

e.g of Table variable

Declare @x Table (ID bigint identity(1,1), Name varchar(50))

Insert into @x (Name) values('Satalaj More')

Select * from @x

********************

Table variables work similar to temporory variables you can get more details about temporory variable and

table variable at here http://www.codeproject.com/KB/database/SQP_performance.aspx

-Satalaj

Currently rated 5.0 by 1 people

  • Currently 5/5 Stars.
  • 1
  • 2
  • 3
  • 4
  • 5