x

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 '11 at 08:32 PM in Default

nidheesh gravatar image

nidheesh
90 10 12 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 '11 at 08:35 PM

Tim gravatar image

Tim
35.5k 32 40 138

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 '11 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 '11 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 '11 at 03:41 AM

Pavel Pawlowski gravatar image

Pavel Pawlowski
22.2k 8 11 21

Are you thinking SS**I**S Pavel?
Sep 02 '11 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 '11 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.

New code box

There's a new way to format code on the site - the red speech bubble logo will automatically format T-SQL for you. The original code box is still there for XML, etc. More details here.

Follow this question

By Email:

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

By RSS:

Answers

Answers and Comments

SQL Server Central

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

Topics:

x535

asked: Sep 01 '11 at 08:32 PM

Seen: 1338 times

Last Updated: Sep 01 '11 at 08:32 PM