Dave, whoops, looks like we both missed the attachment, thanks.

Well Dave, I was hoping for some real benchmark data, but thanks anyway.

Of course the sql needs to be changed to the dialect specific to the platform - that is...

Dave Ballantyne (12/9/2010)

---

Tim Widdup (12/9/2010)

---

Ok , so how could you achieve this in SQL Server 2000? Again, just need the top x from each group ordered by the ID...

Well this is not so much a rant against search engines, or even programming forums, as it is about the number of people offering bad advise in those forums. I...