<div>
NB: 
If we have A,B 
we don't want B,A.... 
thanks
</div>

<div>
Hello, 
I added E to the temp table and the result is wrong! 
it gave 7 records instead of 10. 
 
A &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;C 
A &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;E 
B &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;A 
B &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;E 
C &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;B 
C &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;E 
D &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;E 
 
for instance A,D is missing... 

<pre><code class="code-10 nolinks" id="code-275764">create table #temp(fld varchar(1))
 
insert into #temp
select 'A' union all
select 'B' union all
select 'C' union all
select 'D' union all
select 'E'
 
select fld1, fld2 from (
SELECT distinct t1.fld as fld1, t2.fld as fld2, ranking = dense_rank() over(partition by ascii(t1.fld) + ascii(t2.fld) order by newid())
FROM #temp t1
cross join #temp t2
where t1.fld &lt;&gt; t2.fld
) a
where ranking = 1
</code></pre>
</div>

<div>
<div class="content wysiwyg-content">
Hello, 
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: 
A,B 
A,C 
A,D 
B,C 
B,D 
C,D 
 
How can i do this?? 
thanks
</div>
</div>

Hello,
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:
A,B
A,C
A,D
B,C
B,D
C,D

How can i do this??
thanks

Type of combination in TSQL

Microsoft SQL Server 2005 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. It includes support for managing XML data and allows a database server to be exposed over web services using Tabular Data Stream (TDS) packets encapsulated within SOAP (protocol) requests.