ASp.Net day

Micro blog



About Satalaj

www.satalaj.com

The best inline translator

Live lookup to see what asp.net developers are searching





Reportviewer and Temp Variables       by Satalaj 29. June 2009 10:25
    

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