Well, of course I post my question after hours of hair pulling...and the issue gets resolved shortly thereafter.

In case anyone is interested, this came down to a permissions issue. ...

Thank you everyone for the quick and knowledgeable responses! This works wonderfully now.

Thank you so much!

It needs to be in calendar format for the query:

05/25/2010

If I could also have it in ldate format, (20100525) that would be great too.....but either would work for me.

Excellent! Thank you! It's making more and more sense. Yet, there's so much more for me to learn...Since I'm picking up so many great things from you, I wonder,...

Ok, I definitely better understand the use of DISTINCT and how it really is GROUP BY. I guess I never really thought of it that way before, so thank...

Thank you Paul! Very interesting and very well explained. It seems my suspicions were justified. I guess it does make some kind of sense to have the...

Wow, this is good stuff. Thanks to everyone for looking at this and offering suggestions! I knew SSC was the best place to go with my SQL questions...

That is exactly my question as well. More fields usually means more time to execute, as far as I knew. But it's the opposite in this case!

Those are indeed the columns. They were just commented out in Query2 to demonstrate that if i don't pull both columns, it takes 20 seconds. (I could've just removed...

So...if I confirm that both queries are running on the same server, does that alter what I'd need to do next? (Because they are both running on the same...

Ok, here are the plans.

Hey, thanks for checking this out, by the way. I'm just a little confused by this. Glad to know someone out there might have an inkling...

No parameters in either query (both are just using the same hardcoded date). The execution plan for Query 1, the quick one, shows a clustered Index seek, cost 86%...

Hey, we're experiencing this exact same issue. It's wreaking havoc on our system!! Is there anyone out there with ideas on what we could look for in figuring out this...

So i've gotten as far as determining that the field I have set to "=Sum(Fields!TraveledDistance.Value)" is already summed in the stored procedure. So I removed the Sum and just...

I'm so sorry, but I'm just not getting it. (due to my limited SQL knowledge entirely) Your queries left me banging my head against a wall trying to understand...