There's a much better way to make it fail. Let it select a divisor of 0 and have the query fail for a more practical reason of divide by 0.

Just be sure it has the exact same columns and data types..   Otherwise you're going to need to re-do those reports anyway.

Why not just test the new data source query to be sure it works and then update the SSRS data source?

I'm not in favor of cursors, because there's usually a better way to do this, but your error handling isn't quite the way I would write it, and as I...

Well, what if in your supplied data, for group id = 1, the -20 is actually a void of the two most recent +10 values?   That's typically why void transactions...

I'd also suggest you run your import on the server with the higher version, as it's less likely to have a problem.   SQL 2008 may not be capable of properly...

Then the only possibility is that the account that the job runs under is perhaps not the one you think it is.   A job CAN be configured to run under...

You see that error at the command line?   Find the option that allows you to redirect the log output to a file and then post the contents of the error...

Try changing the order of the LEFT OUTER JOIN to list the CancerTypes table reference first.

Did you also check the SHARE permissions?   NTFS volumes can have permissions at both the folder/file level as well as at the network share level.   If you use the UNC...

I think you may have the cart before the horse here...    For most companies, the definition of "maximum capacity" might well differ.   Some will want to be sure that a...

Let's understand some basics about what CLUSTERED and NONCLUSTERED indexes are:

1.) When you create a CLUSTERED index, that index is actually the table itself, and the table is...

Why use Express Edition?   It is not able to have SQL Agent operate.  Not sure about SSRS, but it might not be capable of that either.   On the other hand,...

+1 for what Sue posted.   The big question here for me is how, exactly, the one query connects to the other server.   Is there a Linked Server involved?   Does the...