shaini.binu (1/14/2010)

---

Hi Lutz,

Thanks for the quick reply,

Regarding the requirement ,

In LinkTable , ID1 contains the uniqueid of a transaction and ID2 contans the uniqueid of the transaction related to it,

One transaction can be related to 0 or many transactions,

We are in the process of creating specific groups for all related transaction.

[font="Arial Black"]Quote: Am I right that you'd need to start a new group as soon as neither one of the numbers in one row has been previously assigned to a group?

Ans: Yes, you are correct ,[/font]

Quote:If so, how would you handle row 6 to be "6 | 101 | 104" instead of "6 | 106 | 104" (both values in a row are preassigned, but to different groups)?

Are the groups supposed to be consecutive or can you "jump back" to let's say group 1 if row 8 would be 8 | 101 | 109?

Ans :

If the linktable contains data :

SID(primary key)|ID1 |ID2

====================

1| 101 | 102

2| 102 | 101

3| 103 | 104

4| 103 | 105

5| 104 | 105

6| 101 | 104

7| 107 | 108

8| 101 | 109

The expected output is:

GroupNum| ID

==========

1| 101

1| 102

1| 103

1| 104

1| 105

2| 107

2| 108

1| 109

Thanks & Regards

Sh.