Why can't you make the call using 4-part naming?

I think I'd do this:

SELECT

c.name AS ColumnName,

t.name + CASE WHEN T.NAME LIKE '%char%'

...

I don't believe that there is a way to do this natively with SSRS. You have to export to Excel for this functionality.

I don't see what columns make up the row unique? Do you want to match a Start Date with an End Date? That's what it looks like to...

You can't pass as parameters using OPENQUERY. It's a bit of a short-coming in my opinion. Can you make the call to the SP using 4 part naming?

Exec...

Jay,

I just saw this behavior this morning when I was doing some remote training for a client. The client was running IE 10 and SSRS 2008 R2, not sure...

Try the syntax from this, https://www.ibm.com/developerworks/community/forums/html/topic?id=77777777-0000-0000-0000-000014307343.

I think I successfully called stored procedures on DB2 across a linked server back in another life and I think I even wrote documentation on...

The execution log also shows the parameters that are being passed to the report. Looking at that might help determine if parameter sniffing is the problem.

When run on the...

I wouldn't expect the 2 queries to have the same execution plan. In the first query the OR condition essentially eliminates the optimizers ability to do a seek on...

Here's a support article for creating a linked server to DB2, http://support.microsoft.com/kb/222937. Is this DB2 on the iSeries? Good luck it's been like 8 years since I've had...

I've never done anything with multiple languages in SQL server so I can't tell you if the change to the agent account will be a problem, but since it caused...

I don' think there is an easy way to do this because you still have to do A.col1 - B.col1 for each column to get a difference. You could...

There is not SQL Server Agent Download from Microsoft, it is part of the SQL Server install for all editions except Express.

Where/how did you get the install for SQL Server...

Okay, are you trying to start the service on a local instance or a remote instance?

Have you verified in the services panel that the RPC service is running and the...

Run this:

SELECT

D.database_id,

D.name,

D.recovery_model_desc,

D.log_reuse_wait_desc

FROM

sys.databases AS D

WHERE

D.name = 'reportservertempdb';

I'm...