If I have 4 values : A, B, C and D
I need a TSQL function that generate all the possible combination
of 2 values together.
Each generated record could not have 2 same values,
and the order is not important.
So, for the (A,B,C,D) values the result would be 6 records as the following:
How can i do this??