Jeff Moden (4/17/2012)

---

capn.hector (4/17/2012)

---

thanks for the tally table code, im still working on getting it through my head exactly how to use them and keep reading every thing on the...

jasemilly (4/18/2012)

---

Thanks for you help and time, yes I see that now!!! I had my query wrong, guess we could have done better on that product, to avoid 2...

its because order number in SOP_CUST_SERVICE_HEADER is not unique. you end up creating a cartesian product with the item marked returned in PROD_ASSEMBLY_BARCODES showing up as error x 27...

the books online articles you may want to look at.

WHERE http://msdn.microsoft.com/en-us/library/ms188047.aspx

HAVING http://msdn.microsoft.com/en-US/library/ms180199(v=sql.90).aspx

IN http://msdn.microsoft.com/en-US/library/ms177682(v=sql.90).aspx

ok first thing is congrats on posting the ddl and sample data. here are the queries posted for a quick glance by every one.

/* original query without a subquery...

I figured if I could not find porky I could find something a little more towards the truth of the...

or maby this

http://www.youtube.com/watch?v=OVtinv5LSnE

Lynn Pettis (4/17/2012)

---

Okay, now we really need that Porky the Pig picture with him say move along, nothing to see here. The OP is "closing the thread". Like...

Revenant (4/17/2012)

---

Ray K (4/17/2012)

---

L' Eomot Inversé (4/17/2012)

---

Revenant (4/17/2012)

---

Thinker

BTW, a suggestion that acute thinker is...

hxkresl (4/17/2012)

---

But how does the middle CTE come to be recognized as 'C' as it isn't named...

hbtkp (4/17/2012)

---

ok ,i m giving sample date this time

this TIME I AM GIVIng SAMPLE DATA plz help

MemberID index

-9 ...

hxkresl (4/17/2012)

---

Yes, first embarrassed that I didn't change the alias for the Maxticket CTE or flip/flop the order of the columns and statements to reflect the hierarchy I was imposing....

you still have the issue of joining on non unique columns. if you take a look order number 7032357 has 3 rows in the table

SELECT *

FROM OrderItems...

Revenant (4/17/2012)

---

Thinker

BTW, a suggestion that acute thinker is one that is not cute is...

Sean Lange (4/17/2012)

---

Hi...