hi
I have a table that has 8 records...
I need to find ALL ways to permute these 8 records in a column subject to the following contraints...
(2,1) precedes (2,2), (3,1) precedes (3,2), (4,1) precedes (4,2), (5,1) precedes (5,2),
(2,1) precedes (3,1), (3,1) precedes (4,1), (4,1) precedes (5,1)
Two possible outcomes are...
Many thanks for any help.
Teach314
I have a table that has 8 records...
Code:
tbl_1
X Rnk
2 1
2 2
3 1
3 2
4 1
4 2
5 1
5 2
I need to find ALL ways to permute these 8 records in a column subject to the following contraints...
(2,1) precedes (2,2), (3,1) precedes (3,2), (4,1) precedes (4,2), (5,1) precedes (5,2),
(2,1) precedes (3,1), (3,1) precedes (4,1), (4,1) precedes (5,1)
Two possible outcomes are...
Code:
tbl_Output
ID Row X Rnk
1 1 2 1
1 2 3 1
1 3 2 2
1 4 3 2
1 5 4 1
1 6 5 1
1 7 4 2
1 8 5 2
2 1 2 1
2 2 3 1
2 3 4 1
2 4 3 2
2 5 5 1
2 6 2 2
2 7 5 2
2 8 4 2
Many thanks for any help.
Teach314