temporary table in ssrs

Temporary table does not work with SSRS 2005 & 2008?.Is there any ways to overcome this difficulty?. Thanks in advance.. Regards, pvn.

more ▼

asked Sep 01, 2011 at 08:32 PM in Default

avatar image

90 13 13 14

(comments are locked)
10|1200 characters needed characters left

2 answers: sort voted first

When I have more complex needs within SSRS I typically put the logic into a stored procedure and call the store procedure within the SSRS Report. I create variables for my end users to enter that get passed to the sproc. So far it has worked well for me.

more ▼

answered Sep 01, 2011 at 08:35 PM

avatar image

40.9k 39 92 168

Where I work I recommend using stored procedures as the default method of providing data to a report data source.

Oh, and many congrats on getting to the 20k karma level. Thanks for bringing your experience and skills to the forum.

Sep 02, 2011 at 05:34 AM Fatherjack ♦♦

Thanks @Fatherjack, it has been a lot of fun and education getting this far. I still say I have gotten more out of participating on this site than I have contributed. AskSSC is simply the best.

Sep 02, 2011 at 10:20 AM Tim
(comments are locked)
10|1200 characters needed characters left

Depends how you would like to use the temp tables. If you would like to use it in subsequent Execute SQL Task or in scripts, there is no problem to use the temp tables. The only problem comes with Data Flow, if you would like to use it as source or destination.

To allow use a temp table among several executables you have to set `RetainSameConnetion = True` on the connection so the same connection is retained between executables. Otherwise each executable starts it's own connection and the temp table is gone.

more ▼

answered Sep 02, 2011 at 03:41 AM

avatar image

Pavel Pawlowski
22.7k 10 15 26

Are you thinking SS*I*S Pavel?

Sep 02, 2011 at 05:33 AM Fatherjack ♦♦

Ah... you are right @Fatherjack. I was writing about SSIS and didn't noticed it's about SSRS.. :-)

Sep 02, 2011 at 12:26 PM Pavel Pawlowski
(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here



Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.



asked: Sep 01, 2011 at 08:32 PM

Seen: 1857 times

Last Updated: Sep 01, 2011 at 08:32 PM

Copyright 2017 Redgate Software. Privacy Policy