Ray K (12/15/2010)

sing4you (12/15/2010)

Cool! What are you playing?

I just sang, played piano, and bass guitar (not all at the same time) for...

Interesting question, even more interesting explanation. Hmmm. I guess my take away from this question, is don't use temp tables in stored procedures.

At least for those of us in the northern hemisphere

Ray K (12/15/2010)

Daniel Bowlin (12/14/2010)

Ray K (12/14/2010)

crookj (12/14/2010)

Ray K (12/14/2010)

Or would that be Korean...

You can't do this all from within SSRS. First thing I would do is create a subscription to the report to create your file. Then use some programmable...

Feelin Good! 😀

I think there is one thing, unmentioned, that we are all assuming. My comments at least were based on requirements that find a roughly 1 day delay between data...

Good question. I wasn't positive of the cut off, so I had to do some research and learn something. Thanks.

Is the error being logged by one of the child packages and then rolling up to the parent package and being logged again?

Running all the columns through a DCNV and defining their data types is generally a good idea in this case. It most likely will save you problems later on...

First ought to work, but it will only return the first value in the data set for each group, so you may not like the results.

Ray K (12/14/2010)

crookj (12/14/2010)

Ray K (12/14/2010)

Or would that be Korean Pairs? (Would my...

I too have always favored staging the data into a new table.

It looks to me like you have a grouping/scope issue. You probably have groups on your report, and you are trying to put a detail field, rather than a...

I have run into an issue called Parameter Sniffing that can cause a report to run painfully slow. This can/does happen when you are feeding parameters from the report...