LutzM (7/16/2010)

---

If you would post the execution plans for both queries it would help us a lot to see what changes need to be made to tune the code. 3...

I'm sorry I misunderstood you.

I ran your 2nd example.

First Version runs in 3 seconds.

Second Version runs in 15 seconds.

Both examples provide the same results.

Again I thank...

That code i posted above ran in 13 seconds. i switched it to a temp table instead of a Table variable and it now runs in 3 seconds.

Here is what i have so far. I changed a few of the field names. Other than that it's exactly what i have. I had to add...

@LutzM

I did not consider to normalize and properly index your tblResults table. I'll have to look up tomorrow on how to do that. I'll also submit the full...

@ Joe Celko:

Thank you for your post as well. It's not a huge table, but can take awhile to process especially when calls from the web are involved. ...

@LutzM Thank you so much. I think this will get me where i need to go.

This was exactly what I was needing. I modified it...

Thanks for the advice. Here are the Creates. I took columns out of the tblResults but it's the same idea, for 30 or more data elements.

CREATE TABLE [dbo].[overall_avgs](

[system_id]...