If both databases are on the same server, you just need to use a 3 part naming convention for your tables in the query.

SELECT one.A, one.B, one.C, two.A, two.B, two.C

FROM...

Timeout

I think the best thing to do would be to get some kind of source control software. There are two kinds of developers, those who use source control and...

Trident

Personally I prefer the NoRowsMessage property to indicate that the report ran but does not contain any data. This way you don't get calls asking why the report did...

Try putting your values in quotes.

What you have

Parameters!P_Period.Value=12

What I am suggestiong

Parameters!P_Period.Value="12"

Also, is Parameters!P_Period a multi value parameter?

I always use stored procedures as my dataset query in SSRS. If you do it this way, you will be able to use OpenQuery within the SP with no...

Audit

Good question. Got it right for the wrong reason, learned something. Thanks.

Late

Ninja's_RGR'us (12/8/2011)

SQLRNNR (12/8/2011)

L' Eomot Inversé (12/8/2011)

Drat, I missed out 6 casts ("0" changed to "cast(cast 0 as datetime) as date)" in...

Come to think of it the UNPIVOT transform would probably be even easier, and almost certainly more efficient.

I think an easy approach would to use a Multicast and then 3 different destination transforms, one for each type.

Cadavre (12/8/2011)

Just to over-complicate matters . . . 😀

SELECT CASE WHEN GETDATE() > DATEADD(d, 24, DATEADD(m, 11, DATEADD(yy, DATEDIFF(yy, 0, GETDATE()), 0)))

...

I can't imagine this many databases on a single server, or for that matter in a single company. It would be an interesting experiment to load up a single...