thanks!

Oh Thanks, awesome!

What about question 2 though? Will having Child procs for the code to run parallel to eachother improve performance?

And can 1 proc run parallel to itself with different...

Thanks!

Originally I had just read the multi-aggregate section. But after you said performance was at the end, I decided to read the whole thing and I learned quite a bit...

Thank you Jeff. Any Idea which one would perform better?

Don't say Join and union all at the same line, it confuses as to wether you are joining or UNIONing these CTEs.

But just to clarify, are you saying that SCROLLING...

Ok thank you for the clarification. Time statistics agree with IO statistics.

Koen (da-zero) (1/14/2011)

---

The second code will surely be much faster, but you've hard coded the condition into your statement.

Are you sure there will always be one row in table2 with...

Working on that.

In the meantime, I guess I...

I'm just trying to understand this code. It's not my own.

And no I dont know if the information in the table will stay the same, or if it will always...

No but he has a book you can buy that proves it!

Joe should just not bother actually making a different post for every thread he posts in and just write...

Lets not forget Intellisense 😀

Thank you, you've been very helpful.

This was an oversimplified version of my proc. I wrongfully assumed that if I ask a question about the where clause, that people would answer the question about the where...

Never mind, the requirements just changed. I can use script component now.