The "why" boils down to your environment. If you don't have control over every facet of object naming, but have code that runs against these objects, then it's your code...

Assuming that this is a repeating process, I'd create a batch file, using UNC names, and call that with xp_cmdshell. Then, any changes you want to make only need to...

Several things, but first, could you copy and paste the actual code, assuming the above isn't it, as I'm guessing it's just a simple syntax error of some sort? You...

"I'm a firm believer in learning hand-assembled machine language where you have to calculate the values of branches both forwards and backwards.  I think it aids in developing critical thinking...

Linkety-link.

I'm very confused by your statements about not using sp_executesql. Are you doing an EXEC (@sqlString), or are you trying to run the SELECT as is? If the former, then...

Have you tried running it manually from the server itself? This sounds like either a permissions, or a scope (i.e., getting data from the local drive) issue, but without knowing...

I'm guessing that some of your DBs are missing either server or member entries, so change your INNER JOINs to LEFT OUTER JOINS, and see if that's the results you...

If memory serves, the 00900 error returns the string it thinks you want to run. Can you tell us what shows up there?

Expand should do the trick for you.

I get that only when I try and look at the transforms from my own box, through EM. If I log onto the server itself, the transforms never hang for...

What? A custom (several actually, for our different web applications) C# web app.

Where? In-house.

How much? Can't sell it, but can help you build your own.

Is a wrapper around the ReportViewer control an option? We use such a beast, and it makes things a bit easier to handle, although getting up to speed can be...

Can you show us what you want the final SQL to look like as returned from the SELECT statement?

I don't know your environment, but have you tried prepending the schema to the sp name?