Select A1.*, B1.* from cur A1 INNER JOIN cur B1 on A1.ID < B1.ID
This should create all possible combinations.
>I have to make sure to cover all combinations
>
>For example I have 3 records in my cursor. I want to make sure that I do the following
>
>Sequence of tests
>
>record 1 then record 2 then record 3
>record 1 then record 3 then record 2
>record 2 then record 3 then record 1
>...
>
>so in total the six combinations
>
>1,2,3
>1,3,2
>2,1,3
>2,3,1
>3,1,2
>3,2,1
>
>There could be more than 4... eventually
>
>How can I make sure to do it programmatically?
If it's not broken, fix it until it is.
My Blog