Paul,

How many DISTINCT values of Rubric does your base table contain. How dynamic are you expecting these to be? (Are these likely to change / be...

Still very limited on the information you are providing to us, but one way you could accomplish this is to use the built in database connection functions within Excel. ...

What the hell, is this like a Florida only forum? :hehe: I had kinda wondered if there was anyone else here that might attend those meetings that I'd meet,...

Yeah, especially the ones with one post who never even come back to see the answers they are given.

rbarryyoung (10/25/2008)

---

Jeff Moden (10/25/2008)

---

Parul Sharma (10/24/2008)

---

I can tell you the answer to that... Seth's will handle a million rows in less than 7 seconds... the others that use a "triangular...

Jack Corbett (10/25/2008)

---

You can go to PASS to find official chapters of SQL Server groups. You can also find out by finding your areas Microsoft Developer Evangelist which you...

Gotcha. Thanks for the explanation.

Ok, first a few notes:

I had to fix a few issues with your CTE, and I added several of my own. This is my first attempt at using CTE's...

jwellington,

Thank you for posting the information requested. I realized today that this one seemed to have kinda slipped through the cracks. So I copied your table...

See the link in my signature for an example of how to post sample data / table structure on the forum.

I edited the original post so that future people won't copy-and-paste the BAD code

I do the same. I wasn't trying to say you did anything wrong... in fact, I...

I've never even heard of...

Yeah, I rewrote that like 8 times, I'm not even sure I understood it by the time I finished.

In any case, you're saying that the optimizer can evaluate things out...

Please post DDL and sample data for your table. (You can see an example of how to do this properly by clicking the link in my signature) How you...

Couldn't this cause situation where an execution plan that...