Hello guys,
I am having a problem and it will be a great pleasure for me if this wonderful community is able to help me out.
I need to extract some information from sql server and manipulate the row and columns that appear.
What I want to do is to put some rows into a different column; And that will only appear when a row has duplicate value.
Example . When I excute the sql statement this is the output I get. The informatio is coming from the same table.

NB: Columns are separate with vertical bars.

SampleNo | Original Value | Processed Value
-------------------------------------------
12345 | 2.34 | 2.30
12345 | 2.34 | 3.36 *
00004 | 3.00 | 3.40
00055 | 8.20 | 8.20
56789 | 5.21 | 5.00
56789 | 5.21 | 5.20 *


I want to execute the sql statement and get output as show below as from the example above. The Duplicate_Value was created in the sql statement.

SampleNo | Original_Value | Processed_Value | Duplicate_Value
------------------------------------------------------------
12345 | 2.34 | 2.30 | 3.36
00004 | 3.00 | 3.40 |
00055 | 8.20 | 8.20 |
56789 | 5.21 | 5.00 | 5.20

As you can see, if the SampleNo appear twice but with different Processed_Value value 'rows with asterisks', then a new column has to be generated and the second value put in the generated column. I want to do this in order to take out duplicate values from the output and put the new value matching the duplicate values into the generated column.
As


NB: Row with same values should be eliminated.


I know you guys will bail me out.

Regards.
Frederick