Nah... I take it back... not clever... freakin' brilliant. The key to this whole thing is the grouping. You've gotta be able to group each "cluster" of rows...

I took a look at the winning solution for that contest... pretty clever.

Jack Corbett (1/31/2009)

---

You should try both, evaluate execution plans, and performance and choose the one that performs best. In my experience Jeff's solutions usually out-perform others.

The only way to...

dubem1 (1/31/2009)

---

It's for statistics purpose to analyse the tendencies of students.

Thanks for the solution, it's not simple, I will try it.

Yesterday I browse the web to find by myself a...

I still would like to know the business reason behind this...

Oh, I absolutely agree... when someone said that SSC would have 10-15 million members in 5-10 years, I made the correction that it would have 200 users and 10-15 million...

LeeBear35 (1/30/2009)

---

I have encountered problems with Merry Go Round issues too. On small samples it would always work but as data sets grew it was more and more of an...

Martin Stephenson (1/30/2009)

---

Great article, I 've been able to apply it to a pain in the neck I've been working on, but at the risk of looking like a thicko...

dubem1 (1/30/2009)

---

Sure

I have a Student table in relation with an exam table. So each student has done n exams.

Each exam has a final cote (the result code in my...

AH! Now that's more like it! Long live "hoopla"! 😛

Thanks for the success story, Gabriel. Like I said, I've not used partitioned tables in production, yet. From all the hoopla in BOL, I have to say I'm...

New haircut, too... although she might try using a little face wax. 😛

If someone or something has the file open when your code runs, it will give such an error message. Bouncing the server seems to clear it because the file...

Correct... and a 30% discount rate would mean you only pay 70% of the unit price and that's the other reason for the 1... you subtract 30% (0.3) from 1...

Thanks, Martin... if someone doesn't beat me to it, I'll give it a whirl after work.