At this point your ideas will be better than mine. I never, ever attempted what you're trying to do. You'll have to test and tweak untill you get...

Ya but since IE still somewhats rules the market :w00t:...

Yup.

I was starting to think this was a late april's fool joke! :hehe::Whistling:

Plan Z, when you are on the correct server, lookup the sql logs about that database, that should give you more info.

Plan ZZ, is it possible to revoke Sys Admin...

Still not working!

That's the whole extent of my experience with that issue. I won't have anything else to offer other than googling for it.

I have no other idea than the sum / count.

Have you considered calculating that 1st avg in the main select? That would take care of the ssrs challenge.

I know...

It's actually "worse" than that. If you want a garanteed index seek, the predicate needs to return 0.3% OR LESS of the data in the table.

Needless to say that...

Start a trace that filters on duration > 50 ms or whatever you feel will get the data back.

Then investigate. It's most likely a set a parameters that could...

Are you logged in the correct instance?

Are you logging as a SA? If not, do you have permissions to access that db?

JohnnyDBA (4/4/2011)

---

I read through the article and tried checking the properties of the SELECT statement, however I do not see the Reason for Early Termination property. I'm running SQL...

Look at my code... it's doing EXACTLY what you need.

You're just proving my point that you need to understand the code before implementing it.

Remember that at 3 AM you'll be...

I don't give the code because I want you to UNDERSTAND 100%.

SELECT SUM(CASE WHEN DATE BETWEEN <Start> AND <END> THEN invoiceamt ELSE 0 END) As Period1

, SUM(CASE WHEN DATE BETWEEN...

Sure of what? I have this is prod without issue, with great performance.

I've simply pasted working code so that he gets the idea of sum(case when period).

That requires s...

Here's the actual working link...

http://www.sqlservercentral.com/Forums/Topic1087470-1550-1.aspx