declare @tb1 table ( partner1 Varchar(5), partner2 Varchar(5) )
insert into @tb1 values( 'A','D'), ('B','E'), ('C','F'), ('D','A'), ('E','B'), ('F','C')
Select * from @tb1 --output has to be like A D , -- B E , -- C F, -- & not repeated like D A ,E B, F C
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)