WayneS (11/1/2010)

---

Great, I'm glad it's working right. Thanks for posting the DML/DDL to produce what you're trying to do.

We don't do that...

Craig Farrell (11/1/2010)

---

James,

First, nice work on the sampleset and work shown. Helped a lot.

I usually use a variant on your Method 2 and 3, along these lines:

select

et.ExampleTableID,

et.ExampleProduct,...

WayneS (11/1/2010)

---

;WITH CTE AS

(

SELECT t.ExampleTableID,

t.ExampleProduct,

t.ExampleValue,

RN = RANK() OVER (PARTITION...