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, 2011 at 08:32 PM in Default

nidheesh gravatar image

nidheesh
90 11 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

Tim gravatar image

Tim
36.4k 38 41 139

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

Pavel Pawlowski gravatar image

Pavel Pawlowski
22.3k 9 11 21

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.

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:

x558

asked: Sep 01, 2011 at 08:32 PM

Seen: 1527 times

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