<div>
select col1 from yourtable<br />
union<br />
select col2 from yourtable
</div>


select col1 from yourtable
union
select col2 from yourtable

<div>
Perfect Pawan! &nbsp;Thanks so much. &nbsp;That got to the number I thought it should be. &nbsp;<br />
<br />
Thanks!
</div>


Perfect Pawan!  Thanks so much.  That got to the number I thought it should be.  

Thanks!

<div>
<div class="content wysiwyg-content">
Hello<br />
<br />
I'm using SQL Server 2008 R2. &nbsp;I have a table with two columns with similar information. &nbsp;In some rows (not all), the information in Column 1 was erroneously switched with the information in Column 2 and vice versa (the data were received this way). &nbsp;<br />
<br />
I need to count the distinct values that exist in both Column 1 and Column 2. &nbsp;<br />
<br />
e.g., given this: <br />
--------------------------<wbr />------<br />
Column 1 | Column 2<br />
--------------------------<wbr />-----<br />
&nbsp; &nbsp; A121 &nbsp; &nbsp;| &nbsp;A121<br />
&nbsp; &nbsp; B111 &nbsp; &nbsp;| &nbsp;C111<br />
&nbsp; &nbsp; D111 &nbsp; &nbsp;| &nbsp;A121<br />
<br />
The distinct count would be 4
</div>
</div>


Hello

I'm using SQL Server 2008 R2.  I have a table with two columns with similar information.  In some rows (not all), the information in Column 1 was erroneously switched with the information in Column 2 and vice versa (the data were received this way).  

I need to count the distinct values that exist in both Column 1 and Column 2.  

e.g., given this: 
--------------------------------
Column 1 | Column 2
-------------------------------
    A121    |  A121
    B111    |  C111
    D111    |  A121

The distinct count would be 4

Counting Distinct values in two columns

Microsoft SQL Server 2008 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. Major improvements include the  Always On technologies and support for unstructured data types.