You might be able to use JOIN() in SSRS, but Sean's right... more details, please!!!

If you want a good answer, ask a good question! (enough details so we can reproduce...

Maybe someone more knowledgeable than I will chime in, but what if you did this with a cursor and scheduled it as a job? (so it runs in off hours)....

only thing i can think of is to do the iffy one inside a TRY/CATCH block and trap for the table not being available (if you can). Then use...

bad form. just post it.

the more eyes on your problem, the faster you get an answer.

http://technet.microsoft.com/en-us/library/ms190307.aspx

look up "sp_send_dbmail" in BOL, or read the article...

You mean you can't run as another user?

If you're an admin, surely you can create a dummy user, connect to the database as that user, and then run whatever code...

Any reason you're storing a number (a date) in an NVARCHAR field? If you can fix that, then the problem would go away.

Did you try casting the value as...

I'm not sure how you would. PK/FK is basically enforcement of matching values and field types (and sizes) in 2 different tables. That said, I posted the only...

Not sure if I'm missing something, but without table definitions, sample data, and expected results it's hard to tell if I'm right...

use Test2;

GO

CREATE TABLE test (

ID INT,

ParentID INT,

ColX CHAR(7)

);

GO

INSERT INTO...

Not sure if I'm missing something, but without table definitions, sample data, and expected results it's hard to tell if I'm right...

use Test2;

GO

CREATE TABLE test (

ID INT,

ParentID INT,

ColX CHAR(7)

);

GO

INSERT INTO...

The correct use for dynamic SQL is Option 1: DON'T, especially if you're a noob.

If you understand the repercussions of code that can't be optimized, and SQL injection attacks, etc,...

Sounds like mirroring will work. The mirror would be used as the report server. It would stay in standby mode, but that does not mean you cannot query...

put them in a rectangle that comes after all the other items in the report?

textbox would have as it's source

=Parameters!ParameterName.Value

You could also put a single row table there, if...

See the second example in this article:

http://access.mvps.org/access/general/gen0008.htm

then once the data is in Access, you can do whatever... (Probably export back out... and go through SSIS as planned.)

One option might be to use Access (shudder, I know) to create a linked table that only links to the data you want and then export that back to Excel...