Lynn Pettis (9/20/2012)

---

erics44 (9/20/2012)

---

Lynn Pettis (9/20/2012)

---

erics44 (9/20/2012)

---

Lynn Pettis (9/20/2012)

---

erics44 (9/20/2012)

---

...

Luis was able to help because at the time he had no opinion of me or the thread and wasnt letting...

Lynn Pettis (9/20/2012)

---

erics44 (9/20/2012)

---

Lynn Pettis (9/20/2012)

---

erics44 (9/20/2012)

---

...

Luis was able to help because at the time he had no opinion of me or the thread and wasnt letting his feelings stop...

Lynn Pettis (9/20/2012)

---

erics44 (9/20/2012)

---

...

Luis was able to help because at the time he had no opinion of me or the thread and wasnt letting his feelings stop him from being...

Sean Lange (9/20/2012)

---

erics44 (9/20/2012)

---

Luis Cazares (9/20/2012)

---

At this moment, I wish I didn't post any response.

Your answers have been rude to someone that is trying to help you by giving a...

Lynn Pettis (9/20/2012)

---

erics44 (9/20/2012)

---

Lynn Pettis (9/20/2012)

---

erics44 (9/20/2012)

---

Sean Lange (9/20/2012)

---

erics44 (9/20/2012)

---

Sean Lange (9/20/2012)

---

erics44 (9/20/2012)

---

Sean Lange (9/20/2012)

---

But same issue of lack of...

Luis Cazares (9/20/2012)

---

At this moment, I wish I didn't post any response.

Your answers have been rude to someone that is trying to help you by giving a good advise.

This might...

Lynn Pettis (9/20/2012)

---

erics44 (9/20/2012)

---

Sean Lange (9/20/2012)

---

erics44 (9/20/2012)

---

Sean Lange (9/20/2012)

---

erics44 (9/20/2012)

---

Sean Lange (9/20/2012)

---

But same issue of lack of details. I guess...

Sean Lange (9/20/2012)

---

erics44 (9/20/2012)

---

Sean Lange (9/20/2012)

---

erics44 (9/20/2012)

---

Sean Lange (9/20/2012)

---

But same issue of lack of details. I guess Luis has his...

Sean Lange (9/20/2012)

---

erics44 (9/20/2012)

---

Sean Lange (9/20/2012)

---

But same issue of lack of details. I guess Luis has his mind reading cap...

you ok...

well spotted pal, the two are linked

completely different problem tho

thanks a lot mate

it works a treat for the example table

issue i have now is that for an 800 row table it takes ages

Hi

Sorry for the bad post

heres the original table

create table #tab

(c1 int, c2 int)

insert into #tab values (10, 20)

insert into #tab values (10, 30)

insert into #tab values (30, 20)

insert into #tab...

if you look at the RelatedCs with the Related ID of 1

RelatedCs ID

10 1

20 1

30 1

60 1

80 1

you can tell they are related by looking at the following rows...

thansk for the replies

plenty to go off