The latest post you've made states that you've got a connection error, which is separate to the above. SSIS is advising it can't connected to ServerDB. Check that your login...

To pass a variable in SSIS in the Execute SQL Task node, you use a ?, and then add map your parameters on the Parameter Mapping Pane.

So, for example. Say...

I'm afraid I don't really understand what you're asking for here. Can you provide some detail on what your sample data looks like and the end result.

Your best option, if you don't want the data to be shown at all, is using a filter on your tablix.

Open the Tablix properties window, and then select the Filters...

It might be easier to show you if you provide some sample data. Can you provide a create statement with some fictitious data, should help me to explain better, won't...

Sorry I misunderstood the question initially.

Is this dataset likely to grow at all? If you have multiple "applicable" resuts for a single locations (like dubaiin ths example), I can quickly...

tmmutsetse (5/30/2016)

---

Good day Experts,

I have a table with the following columns Name , Memory, Model

I...

You're almost there. A join will always return every valid row, so yes, you'll have multiple joins here.

A better approach would be using APPLY, as follows:

SELECT a.Time, b.Time AS [Time(B)],...

No filters, just groupings. This doesn't really answer why it takes 10 minutes to "load". There's not many rows...

Have you tried running a trace to see what SQL SSRS is actually running? If you have parameters involved, it may be it's passing a value you're not expecting and...

I hate to say it, but your 9% is correct, for the maths you've supplied at least. You're creating an overall % using that formula, not an average of your...

Create a parameter in your report, and create filter on your results based on that. Then set the parameter to the value you need for that subscription so that you...

I assume you have no version control at your workplace? If not, I strongly suggest you implement it, as it will solve issues like this in a flash.

As for restoring...

I'm not sure why you have SUM's in your current expression, as the sample data you've provided is a single line. Therefore you're summing a single number, which always results...

You haven't accidentally changed your configuration at all have you? Each configuration will have a different TargetServerURL, so if you changed from Release to Debug, for example, you may not...