Hey guys,

Thanks so much for the suggestions! I found the exact query that produces different results each time I execute it. I'm still not exactly sure why, but there aren't...

Thanks for the suggestion, Gerald.

I've run it section by section, but without the row count changing intermittently, it's very difficult to pinpoint the exact problem.

Mike

The query executes succesfully but the column header still displays the wrong name.

Again, thank you Koen!

Hi Koen,

Thanks for the response!

Can you recommend any other good end-user reporting tools besides Power View that have good options and are user friendly?

Thanks,

Mike

All,

Thanks so much for the responses. It looks like a few jobs were still executing according to the Job Activity Monitor. One I stopped them, everything was back to normal.

Thanks...

Thanks, Keith! That's just what I was looking for.

Mike

Standard :-/

That property is set to true, so I wonder if there's another contributing factor.

Jack,

Thanks for the reply! It looks like quite a few of the statistics are out of date. The database in question is owned by a third party and I'm not...

Thanks, guys. Very helpful!

Celko,

You kill me with your responses...

Gsquared,

Thanks for the reply. After rewriting the query, the process now runs in one second (down from 20 seconds / not completing at all), so I'm not sure it's worth...

A few things to clarify...

1) It's the query that makes up the view that never completes. It churns along in SSMS. No records are returned while it's running, the timer...

sunilk, yes -- the solution I used was the one opc suggested. It did exactly what I was looking for. I would use that.